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
Adding Months to theExisting Months
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 82
- Joined: Fri Jun 03, 2005 5:23 am
- Location: Bangalore
- Contact:
Adding Months to theExisting Months
Rajasekhar
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Download date routines from my website and use the AddMonths routine.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.