Function module for comparing dates and times

[Former Member]

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!

[RichHeilman]

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

[Former Member]

Use Offset or SPLIT and then compare.

Regards,

Amey

[ferry_lianto]

Hi Krishen,

Please check this FM.

SD_DATETIME_DIFFERENCE

SD_CALC_DURATION_FROM_DATETIME

Regards,

Ferry Lianto

[Former Member]

CCU_TIMESTAMP_DIFFERENCE

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