DateAdd (1 Viewer)

[Pat Hartman]

Like i have a date "30-Jul-2024", i want to give a me date "29-Jun-2027".

What is the rule in words? Add 35 months and subtract 1 day? What does the subtract 1 day do? What happens if the day is 1? then you go back to the last day of the previous month?

 

[Gasman]

I seriously cannot believe this is what you want to do? :-(
Unless the term is a stupid number, you would probably add the interval, years,month,days, hours,minutes whatever and subtract 1 ?
So a bus pass starts from 30/06/24 and last for 10 years. Expiry date is 24+10 less 1 day, so 29/06/34?