Diffrence between 2 Dates Rounded down

[Former Member]

Hello Experts,

How do I calculate difference between 2 dates in Years, Months & Days

I have tried the function  FIMA_DAYS_AND_MONTHS_AND_YEARS, the problem in this function return the values Rounded up

I need the similar function returns the same values Rounded DOWN

Thanks

[Former Member]

What do you mean by "Rounded DOWN"? Don't you want to consider the DATE_TO parameter in the interval? If it's the issue just decrease the date_to parameter by 1 day.

[amy_king]

Hi Jamil,

Use I_FLG_SEPARATE = true. This tells the FM to consider each of month, day and year separately. If this doesn't resolve your issue, please reply with example input and what you expect to get as a result.

Cheers,

Amy