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
"pmclinn" <pe***@mclinn.com> wrote in message
news:11*********************@c13g2000cwb.googlegro ups.com...
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