Date Calculations

[Polarbilly]

I'm new to Access and having problems using dates in calculations...


I want to use these in a form :

Date Field: Date()
Date Of test: "Date Field"
Date of Next Test:"Date of Test" + 180 days
Days Overdue: Date() -"Date of Next Test"


I've tried to work it out using expressions, but don't think I'm grasping the syntax....I come from the simple world of the Approach database where you can create calculated fields in the table...

Any help, guidelines, clues greatly appreciated

[NTC]

well you need to preceed most of those always with an = sign

and you need to use brackets [ ] around names that have a space rather than quotes " "

+180 is ok, but then look up the DateAdd method and copy that syntax - as you will need that too.

Hope it helps.

[Polarbilly]

well you need to preceed most of those always with an = sign

and you need to use brackets [ ] around names that have a space rather than quotes " "

+180 is ok, but then look up the DateAdd method and copy that syntax - as you will need that too.

Hope it helps.

Thanks for the info... DateAdd is working but I can't get the syntax to work

to show the number of days overdue by using =([Retest Date]-[Cert Date])
Can you help???