Dates in MS Access

[Jomacot]

How do I create a date one year on from a manually entered date, i.e. I enter a date in one field but I need another field in the same record to show a date one year on from it.

I can then use the <Now() function in a query to throw up records over one year old.

 

[SamDemon]

Why not run the query with the following formula:-

Date()-365

Sam

It's just common sense, shame sense isn't common!

 

[PHV]

You may also consider the DateAdd function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[willir]

Definitely consider using DateAdd...
=DateAdd("y", 1, Nz([YourDateTextBox], Date))