Macro? ode?

S

Sue

I want to place a control on my form which will calculate the number of days
from now until a specific date in the future - always the same date in the
future, in this case July 5, 2008. Not sure how to achieve this. Help?

Thanks.
 
B

BruceM

You could use the DateDiff function. In the control source of an unbound
text box:
=DateDiff("d",Date(),#7/5/08#)
See Help for more information about DateDiff. Note that the fixed date
needs the # delimiters. If the date in question is a control on the form or
a field in the form's record source, you can refer to that instead:
=DateDiff("d",Date(),[YourField])
 
Top