months between two dates.

[Former Member]

i want to hav, how many months are there b/w two dates. m using ,,

months_between_dates fn. but the problem is if i give two dates as

22.06.2007 and 05.07.2007. it gives me 1 month but it is actually not complete month. i want to hav accurate difference like 0.77. which fn should i use....

[Former Member]

Hi,

'FIMA_DAYS_AND_MONTHS_AND_YEARS'

FM CSCP_PARA1_GET_PERIODS.

MONTHS_BETWEEN_TWO_DATES

MONTHS_BETWEEN_TWO_DATES_NEW

HR_99S_MONTHS_BETWEEN_DATES

HR_MONTHS_BETWEEN_TWO_DATES

<b>Rewrad points</b>

Regards

[Former Member]

Hi

There is no such exact fun module

first get the days between dates and divide those days by 30 (depending on month), which gives exact value.

Reward points for useful Answers

Regards

Anji

[Former Member]

Hi,

I dont think we can get the FM for your requirment but use this FM HR_ECM_GET_PERIOD_BETW_DATES and deduct the no of days by 30 to get the month

Regards

Shiva

[Former Member]

Hi,

can you explane the result 0.77.

What shell be calculate?

(30 - 22 + 5) / 30 -> days in june

or

(30 - 22 + 5) / 31 -> days in july

Regards, Dieter