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

MS ACCESS – DateAdd Function????????

by qps . Updated 23 years, 8 months ago

I have a date field that will always have dates entered in on the last day of any given month. (ex. 12/31/02).

There is a DUE DATE for the above field that is always the 15th day of the 3rd month after the above date field. (ex: if the date fieldis 12/31/02 – the due date should always be 3/15/03)

Does anyone know a text expression I can use to calculate this?? I tried using the DateAdd function to add 75 days to the above date field, but that doesn’t take into consideration months thatonly have either 30 or 31 days, not to mention 28 in Feb.

I don’t know any VB scripting so if this is possible using a text field expression I would like to know?

This discussion is locked

All Comments