Hi All, Currently I am working on a requirement where we need to comp

souravs

Certified Lead Developer

over 9 years ago

Hi All,

Currently I am working on a requirement where we need to compute the number of months based on start date and end date. Suppose say for example start date is 25/12/2015 and end date is 31/03/2017. The total number of months should be calculated as 15 months including the date precision. How to achieve this functionality?

Discussion posts and replies are publicly visible

Parents

0 janakik over 9 years ago

I don't think calWorkDays() function will work for his requirement.

May be you can make use of below expression
tointeger((ri!endDate-ri!startDate)/ri!days)
Where ri!days is average number of days for a month - 30
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 janakik over 9 years ago

I don't think calWorkDays() function will work for his requirement.

May be you can make use of below expression
tointeger((ri!endDate-ri!startDate)/ri!days)
Where ri!days is average number of days for a month - 30
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data