Macro? ode?

[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.

 

[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])

 

[Brian]

Make a text box, and enter this as its control source:

=#7/5/2008#-Date()