计算我的天数增加到2个问题.. [英] Calculating my days increment to 2 problem..

问题描述

hi


我的日子有问题..因为我进入1年3个月和1天......它应该是456 ..而不是1天它给了我3天比如增加2，等于458天。它对于几个月和几天来说是相同的。它和它提供了正确的输出但是包括所有（年，月，日）它也给出了错误的结果..我更喜欢结果几天不能完美地工作

hi
my days till has the problem..since i enter 1 year 3months and 1 day...it should be 456..instead of 1day it gives me 3 days like it increment by 2,equal to 458days. it is the same for Months and days.Years and Days it gives correct output but to include all(year,months, days,) it gives the wrong result as well..i prefer the result for days not work perfectly

Public Function RaceDate(length  As Integer ) As String

              dim year As string=0
              dim month As string=0
              dim day As string=0
              dim ReturnString As string

ReturnString=""

If length = 0 then
Return String.Empty
end if

if length >= 365
year=cstr((Math.Floor (length / 365)))
length  =(length  Mod 365)

end if

If length >= 30 AndAlso length < 365 Then
month =cstr((Math.Floor(length / 30 )))
length  =(length  Mod 30)


end if

if length < 30 Then
day =cstr(length)
End If

If cint(year) >0
ReturnString= year+"  Years  "

End if

If cint(month) >0

ReturnString= ReturnString +month+" Months "

End if

If cint(day) >0

ReturnString = ReturnString+day+ " Days "

End if

Return (ReturnString)

End Function

提前感谢

thanks in advance

推荐答案

为什么要这么乱？请参阅：

http://msdn.microsoft.com/en -us / library / system.datetime.aspx [ ^ ]，

http ：//msdn.microsoft.com/en-us/library/system.datetime.adddays.aspx [ ^ ]，

http://msdn.microsoft.com/en-us/library/system.datetime.addmonths.aspx [ ^ ]。



您是否考虑到不同的年份和月份有不同的天数等？随你。如果您只是想自学编程，请使用调试器并检查您的中间数字应该是预期的。

-SA

Why doing all that mess? Please see:
http://msdn.microsoft.com/en-us/library/system.datetime.aspx[^],
http://msdn.microsoft.com/en-us/library/system.datetime.adddays.aspx[^],
http://msdn.microsoft.com/en-us/library/system.datetime.addmonths.aspx[^].

Do you take into account that different years and months have different number of days, etc? Whatever. If you just want to teach yourself to program, use the debugger and check up your intermediate number with what should be expected.

—SA

使用它，一定会有效。

Use this, will definitely work.

SELECT DATEADD(day,2,OrderDate) AS OrderPayDate
FROM Orders

如果有帮助，请标记为答案。

Please mark as answer if helped.

使用 DateTime.AddDays 和 DateTime.AddMonths 方法..

这篇关于计算我的天数增加到2个问题..的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！