Adding Months to theExisting Months
Posted: Thu Jul 05, 2007 10:26 am
Hi,
In one of my Job I need to add exactly 3 months days to the existing date.
Suppose if the Incoming date is coming as 2007-01-01 then output date should be 2007-04-01
So for this I can use MonthFromDate function to extract the Month from the input date and adding 3 value for that doesn't give the accurate results. Since everymonth has different no.of days.
So any sugessions please to achive the accurate 3 months days(According to Corresponding no.of days from the respective month) addition to the existing Date?
Thanks
In one of my Job I need to add exactly 3 months days to the existing date.
Suppose if the Incoming date is coming as 2007-01-01 then output date should be 2007-04-01
So for this I can use MonthFromDate function to extract the Month from the input date and adding 3 value for that doesn't give the accurate results. Since everymonth has different no.of days.
So any sugessions please to achive the accurate 3 months days(According to Corresponding no.of days from the respective month) addition to the existing Date?
Thanks