topic Re: Diffrence between 2 Dates Rounded down in Application Development and Automation Discussions

Diffrence between 2 Dates Rounded down

Former Member — Mon, 22 Oct 2012 09:47:51 GMT

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

Re: Diffrence between 2 Dates Rounded down

Former Member — Mon, 22 Oct 2012 11:16:40 GMT

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.

Re: Diffrence between 2 Dates Rounded down

amy_king — Mon, 22 Oct 2012 15:55:23 GMT

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