DSXchange

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

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.

ray.wurlod wrote: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 functi ...

Thanks Ray