Getting one date field to project a year later on another field???

TYLER_DURDEN

Registered User.
Local time
Today, 14:08
Joined
Mar 20, 2003
Messages
22
I have one field with dates on it, I want another field to be the result of the first field plus 365 days later. Not sure how to go about this, if someone could help I'd greatly appreciate it!!!

thanks:)
 
Look up the DateAdd() function in the help files.
 
If one field is a function of another there is no advantage to storing both values, use a query to calculate the date for you using the DateAdd function.
 

Users who are viewing this thread

Back
Top Bottom