topic Re: months between two dates. in Application Development and Automation Discussions

months between two dates.

Former Member — Fri, 22 Jun 2007 11:19:58 GMT

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....

Re: months between two dates.

Former Member — Fri, 22 Jun 2007 11:24:36 GMT

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

Re: months between two dates.

Former Member — Fri, 22 Jun 2007 11:25:25 GMT

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

Re: months between two dates.

Former Member — Fri, 22 Jun 2007 11:26:30 GMT

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

Re: months between two dates.

Former Member — Fri, 22 Jun 2007 11:29:28 GMT

Hi,

can you explane the result 0.77.

What shell be calculate?

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

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

Regards, Dieter