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 chetany
A Score Level 1
over 9 years ago

It can also be done using the fn!tointervalds() function. Here is my solution:
with(
local!interval1: fn!tointervalds(ri!startDate),
local!interval2: fn!tointervalds(ri!endDate),
local!diff: local!interval2 - local!interval1,
fn!tointeger(local!diff/30)
)

This works for the example input given by souravs. I have also tested it for other values. There still maybe a few corner cases where it does not work.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 chetany
A Score Level 1
over 9 years ago

It can also be done using the fn!tointervalds() function. Here is my solution:
with(
local!interval1: fn!tointervalds(ri!startDate),
local!interval2: fn!tointervalds(ri!endDate),
local!diff: local!interval2 - local!interval1,
fn!tointeger(local!diff/30)
)

This works for the example input given by souravs. I have also tested it for other values. There still maybe a few corner cases where it does not work.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data