Between Date to Date

chillisrp · Post by **chillisrp** » Sat Jan 17, 2009 11:06 pm

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

ray.wurlod · Post by **ray.wurlod** » Sun Jan 18, 2009 2:48 pm

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.

chillisrp · Post by **chillisrp** » Mon Jan 19, 2009 9:16 am

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