General discussion
December 27, 2002 at 10:42 AM
qps

MS ACCESS – DateAdd #2

by qps . Updated 23 years, 9 months ago

I have 3 date fields that could contain any given date entered.

Is there a text expression I could write that will – – 1. look at each of those above 3 date fields, then 2. Determin which is is the latest date of all three, then 3. Add 1 month to that latest date of the three??? (ex: 1/1/02 | 2/15/02 | 6/28/03 | – Result should be 7/28/03)

I don’t know any VB scripting so if a text field is possible I would prefer that.

This discussion is locked

All Comments