Date Calculations

[Guest]

I have a form where the user can enter the day a customer pays their
registration fees (=[GrantDate]). The fee is good for a certain period of
time (=[Expiration]).

What I would like is to have a control that says whether the account is
within 60 days of becoming expired. How would I do that?

 

[Guest]

First things first. you need to determine the 60 days mark. you can easily
do this using the dateadd function

warnDt=dateadd("d",-60,Me.Expiration)

Then you simply use and if statment to control a control's caption or make a
msgbox appear....

If date() >= warnDt then
'change control to reflect warning or send msgbox warning.....

End if