topic Function module for comparing dates and times in Application Development and Automation Discussions

Function module for comparing dates and times

Former Member — Mon, 30 Apr 2007 19:30:07 GMT

Hi,

I have a date and time stamp in one filed for example as below:

20070125183045

(the first 8 are date in YYYYMMDD format, the next 6 is time in HHMMSS format). Now I want to compare this value to another such value in terms of date and time. First I want to compare dates and then times. Do you know any function module that can serve this purpose?

Thanks very much!

Re: Function module for comparing dates and times

RichHeilman — Mon, 30 Apr 2007 19:33:48 GMT

You can compare these using the function module DURATION_DETERMINE. This fuction will give you the difference, and it can be in a view different units, such as the difference in days, months, etc.

Funciton module takes in Start date and time and end date and time.

Regards,

RIch HEilman

Re: Function module for comparing dates and times

Former Member — Mon, 30 Apr 2007 19:34:30 GMT

Use Offset or SPLIT and then compare.

Regards,

Amey

Re: Function module for comparing dates and times

ferry_lianto — Mon, 30 Apr 2007 19:34:37 GMT

Hi Krishen,

Please check this FM.

SD_DATETIME_DIFFERENCE

SD_CALC_DURATION_FROM_DATETIME

Regards,

Ferry Lianto

Re: Function module for comparing dates and times

Former Member — Mon, 30 Apr 2007 19:36:51 GMT

CCU_TIMESTAMP_DIFFERENCE

here you can use it as timestamp itself. no need to split to time and date.