Leap year validation(vb.net 2005)

[yoosufshanij]

how do i get total no of days between two days which might include leap year

right now i'm getting the no of days by using DateDiff function in vb.net.
but i reckon it is not precise. cos it is not validating leapyear.

pls advise me the best solution for the above

its very urgent

[danasegarane]

How about this one

Dim startDate As Date = "29/05/2009"
        Dim endDate As Date = "02/06/2009"
        Dim DaysBetweenDate As Integer = (endDate - startDate).Days

[yoosufshanij]

i'm getting the no of days between two days by using a vb function like
DateDiff(DateInterval.Day, fromDate, toDate)

but mi problem is of leap year
i want to handle that
pls advise me how to handle leap year in this datedifference

[jmcilhinney]

You've already been given your answer.

[yoosufshanij]

but the result i'm getting is not precise bcos of leap year

[JugglingReferee]

but the result i'm getting is not precise bcos of leap year

What are your two dates?

[techgnome]

but the result i'm getting is not precise bcos of leap year

I'm curious as to how you arrived that the result is "imprecise"....
What are you getting that you aren't? What are you not getting that you expect? What code are you using to determine that it isn't right?

-tg

[jmcilhinney]

The calculation provided works exactly as it should. Try running the following code in a new console application project:

Dim d1 As Date
Dim d2 As Date

d1 = #7/1/1899#
d2 = #7/1/1900#

Console.WriteLine((d2 - d1).Days)

d1 = #7/1/1999#
d2 = #7/1/2000#

Console.WriteLine((d2 - d1).Days)

d1 = #7/1/2001#
d2 = #7/1/2002#

Console.WriteLine((d2 - d1).Days)

d1 = #7/1/2003#
d2 = #7/1/2004#

Console.WriteLine((d2 - d1).Days)
Console.ReadLine()

As you can see, 2000 and 2004 are correctly picked as leap years while 1900 and 2002 are correctly picked as not leap years.

It's my guess that it's your understanding of the calculation that is wrong. Consider this:

Dim d1 As Date = #1/1/2000#
Dim d2 As Date = #1/2/2000#

Console.WriteLine((d2 - d1).Days)
Console.ReadLine()

What would you expect that to display? I'm guessing that you would expect 2, while it actually displays 1. That's because it's calculating the amount of time between 12 AM on the first day and 12 AM on the second day. That is 24 hours, which is 1 day. You need to take that into account when doing your calculations. If you want the number of days in a date range INCLUSIVE of the two dates you specify then you'll have to add 1 to the result of that calculation.