Software

Ask something
Discussion Locked

MS ACCESS - DateAdd #2

0 helpful
4 replies

by qps

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

4 replies

by dklippert

After determining the latest date using Max, the expresssion you're loooking for is DateAdd.

Add one month:
=DateAdd("m", [OrigDate], 1)

Add 45 days:
=DateAdd("d", [OrigDate], 45)

by qps

The MAX expression results in giving me the MAX date from the whole table.

I have 3 date fields per record

(Ex: [Name] [Date1] [Date2] [Date3]

I just want the Max date of the three for EACH record.

Any suggestions??

This discussion is closed to new replies.