Date math Question.

[pmclinn]

If you have date a = 12/11/2004
and you want to see how many days it has been to NOW()
What is the most efficient way to perform this equation?

-Peter

 

[Peter Proost]

Hi

d1 = Now.Date
d2 = Date.Parse(txtDate.Text)
MsgBox("The difference is: " & DateDiff(DateInterval.Day, d1, d2) & " days")

but for the result you want you have to change d1 and d2 so:

MsgBox(DateDiff(DateInterval.Day, d2, d1) & " days have passed")

hth
greetz Peter

 

[Cor Ligthert]

Peter,

The timespan has an limited value, however for this is the timespan
structure

http://msdn.microsoft.com/library/d.../cpref/html/frlrfsystemtimespanclasstopic.asp

I hope this helps?

Cor

 

[Herfried K. Wagner [MVP]]

If you have date a = 12/11/2004
and you want to see how many days it has been to NOW()

\\\
Dim d1 As Date = #10/10/1999#
Dim d2 As Date = Date.Now
MsgBox(d2.Subtract(d1).Days.ToString())
///