dates calculation help...

[Former Member]

I want to be able to return a value that states : "2 Years-7 Month-12 Days" between the two dates?

[Former Member · Accepted solution]

Hi,

You can achieve the same using the following steps. The mentioned steps are to calculate them at the report level.

If you want to calculate them at the DB level you can convert the same.

 
Years = MonthsBetween(date1;date2)/12

Months = (MonthsBetween(date1;date2) - (Years *12))

Days = DaysBetween(date1;date2) - ( Years * 365 + Months * 30 )

Then Concatenate the three variables to get the required result.

Regards,

Rohit

Edited by: rohit12 on Oct 6, 2009 2:41 PM

[Former Member · Accepted solution]

Very nice!

Thanks Rohit