topic Re: Abt date difference. in Application Development and Automation Discussions

Abt date difference.

Former Member — Mon, 18 Feb 2008 14:09:19 GMT

hi,

i have two dates available.

i have to find difference in month between dates.

Re: Abt date difference.

Former Member — Mon, 18 Feb 2008 14:12:30 GMT

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

Re: Abt date difference.

Former Member — Mon, 18 Feb 2008 14:13:10 GMT

see this

Regs

Re: Abt date difference.

Former Member — Mon, 18 Feb 2008 14:13:56 GMT

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

Re: Abt date difference.

JozsefSzikszai — Mon, 18 Feb 2008 14:14:30 GMT

hi Abdur,

pls. try the FM:

HR_HK_DIFF_BT_2_DATES

output format has to be 05 for months.

hope this helps

Re: Abt date difference.

Former Member — Mon, 18 Feb 2008 14:20:13 GMT

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

Re: Abt date difference.

Former Member — Mon, 18 Feb 2008 14:20:59 GMT

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