topic Re: Fun.module for date diff in Application Development and Automation Discussions

Fun.module for date diff

Former Member — Wed, 29 Nov 2006 13:38:36 GMT

Hello,

Is there any function module available for giving the difference between two dates.

For ex:

date1 = 01/30/2000; date2: 02/30/2002

If I query for difference it should in below format :Years & Months.

i.e the difference between date2 & date1 should be shown as 2 years 1 month.

Thanks,

Kanaka

Former Member — Wed, 29 Nov 2006 13:43:01 GMT

hi,

Use FM RKE_SELECT_FACTDAYS_FOR_PERIOD or use FM 'DAYS_BETWEEN_TWO_DATES'

Regards,

Santosh

Former Member — Wed, 29 Nov 2006 13:43:32 GMT

hi,

There is no need of any function module for knowing the differnece in dates.

v_diff_days = date1 - date2.

You get the difference in no of days.

Later you can divide it by 365 and know the difference in years.

v_yrs = v_diff_days/365.

Regards,

Sailaja.

Former Member — Wed, 29 Nov 2006 13:44:03 GMT

Hi Kanaka,

You can use the function module HR_HK_DIFF_BT_2_DATES for finding the difference between two dates in your desired format.

Regards,

Vinod.

Former Member — Wed, 29 Nov 2006 13:46:04 GMT

FIMA_DAYS_BETWEEN_TWO_DATES

DAYS_BETWEEN_TWO_DATES

regards

aswin