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?