Hi all,
Is there a way to add n number of months to a specified date? E.g. if a date is 01/01/2007 then adding 5 months to that date should give 01/05/2007.
It's easy enough to add the number of days to the date but I want to avoid situations where the date is 31/01/2007 and adding 5 months (in days) would give 31/05/2007, which is an invalid calendar date.
Many thanks
Is there a way to add n number of months to a specified date? E.g. if a date is 01/01/2007 then adding 5 months to that date should give 01/05/2007.
It's easy enough to add the number of days to the date but I want to avoid situations where the date is 31/01/2007 and adding 5 months (in days) would give 31/05/2007, which is an invalid calendar date.
Many thanks