Abt date difference.

[Former Member]

hi,

i have two dates available.

i have to find difference in month between dates.

[Former Member]

Check these FM's

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

[Former Member]

see this

Regs

[Former Member]

Hi,

HR_99S_INTERVAL_BETWEEN_DATES

use tjhis FM u can get weeks in between them days and even more check it once if it is helpfull plaa reward..

[JozsefSzikszai]

hi Abdur,

pls. try the FM:

HR_HK_DIFF_BT_2_DATES

output format has to be 05 for months.

hope this helps

ec

[Former Member]

Hi,

You can use below FMs to calculate days and months for given two days.

DAYS_BETWEEN_TWO_DATES "For Days

MONTHS_BETWEEN_TWO_DATES "For months.

Thanks,

Sandeep reddy

[Former Member]

CALCULATE_DATE

Increase/decrease DATE by a specific number of Days/Months

DATE_COMPUTE_DAY

Returns day of the week for a particular date(1=Monday, 5=Friday etc.)

DATE_TO_DAY

Returns day of the week for a particular date('Monday', 'Friday', 'Sat.')

DETERMINE_PERIOD

Retrieve fiscal year and payrole period (Note: verision parameter is fiscal year varient from table T009)

RP_CALC_DATE_IN_INTERVAL

Import parameters Value

DATE 12/28/2006

DAYS 04

MONTHS 00

SIGNUM +

YEARS 00

Export parameters Value

CALC_DATE 01/01/2007

DATE_IN_FUTURE -

Import: date in current external format for user; number of days.

Export: calculated date in future in external format mm/dd/yyyy