Very easy Date Question. Thanks for the help!

[Benjamin Bolduc]

Hello!

All I need is a simple control on a form that counts down the number of days between the current date and 3/6/2004. It seems so easy and yet I cant figure out how to do it.

Thanks for your help!!

 

[Shadez]

The most comprehensive way of counting the difference between 2 dates (That i know of)

is to use the VBA function DateDiff.

DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]])

eg

days = datediff("d",txtSomeDate,"6 Jun 2004")

ShadeZ

 

[Mark Wild]

Have a look under DateDiff

Will go something like datediff("d",date(),date2)

 

[Benjamin Bolduc]

Worked like a charm. Thank for the help Shadez!