Hi Guys,
How to get duration of Months ,Days And Years Between 2 Dates.Example i have requirement like : start date 09/01/2008, expiry date 01/05/2009.
Please help me...Thanks
Chilli
Between Date to Date
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can get days between two dates (DaysFromDateSince() function). The rest should be arithmetic. However, you need to document your business rules thoroughly, and will probably need a custom function, to generate interval as years, months and days.
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.