Macro? ode?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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])
 
Back
Top