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 Mike Schmitt
Certified Lead Developer
over 9 years ago

I also agree with a soution using the month() function. Before some of the more recent replies I wrote the following simpler snippet (then got distracted and forgot to post).

with(
local!start: month(ri!start)+(12*year(ri!start)),
local!end: month(ri!end)+(12*year(ri!end)),

local!end - local!start
)

This example basically just calculates a sum of total months based on the month and year, disregarding the days (so 2015/12/31 to 2016/1/1 would count as 1 month since it crosses 1 month boundary) - so this would have to be tweaked if desired.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Mike Schmitt
Certified Lead Developer
over 9 years ago

I also agree with a soution using the month() function. Before some of the more recent replies I wrote the following simpler snippet (then got distracted and forgot to post).

with(
local!start: month(ri!start)+(12*year(ri!start)),
local!end: month(ri!end)+(12*year(ri!end)),

local!end - local!start
)

This example basically just calculates a sum of total months based on the month and year, disregarding the days (so 2015/12/31 to 2016/1/1 would count as 1 month since it crosses 1 month boundary) - so this would have to be tweaked if desired.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data