topic MONTHS_BETWEEN_TWO_DATES_NEW in Application Development and Automation Discussions

MONTHS_BETWEEN_TWO_DATES_NEW

former_member220286 — Mon, 29 Jun 2015 13:45:04 GMT

I am entering below inputs in the above function module : -

I_DATUM_BIS = 01.06.2015

I_DATUM_VON = 01.07.2014

I_KZ_INCL_BIS = *

I_KZ_VOLLE_MONATE = x

When I execute the above function module with above inputs I am getting the output : - 1.100000000000000E+01

What type of number I am getting in month as this function module gives the month between two dates ..please suggest ??

Re: MONTHS_BETWEEN_TWO_DATES_NEW

Former Member — Mon, 29 Jun 2015 14:14:18 GMT

Deepak,

why don't you use the FM FIMA_DAYS_AND_MONTHS_AND_YEARS. This gives back clear results.

Thanks,

Vikram.M

Re: MONTHS_BETWEEN_TWO_DATES_NEW

rajkumarnarasimman — Mon, 29 Jun 2015 15:17:35 GMT

Hi Deepak,

The FM MONTHS_BETWEEN_TWO_DATES_NEW is returning the month in exponential form. If you want to convert the exponential value to normal value, you can FM QSS0_FLTP_TO_CHAR_CONVERSION

Regards

Rajkumar Narasimman

Re: MONTHS_BETWEEN_TWO_DATES_NEW

Former Member — Mon, 29 Jun 2015 17:21:21 GMT

Hi Deepak,

You are passing the date fields in wrong format. Check your user profile. It must be accepting MM/DD/YYYY or something else other than DD.MM.YYYY. You can test it in SE37.

Look below example with screenshot.

Regards,

Raju Shrestha

Re: MONTHS_BETWEEN_TWO_DATES_NEW

GauravKoundal — Mon, 29 Jun 2015 17:29:36 GMT

Use HR_MONTHS_DIFFERENCE_TWO_DATES.