How to calculate difference between two dates

[#1]

Hi,

I know there are similar posts related to this; I've gone over them but didn't quite get what I wanted. I need to calculate the difference between two dates ClearingDate and NetDueDate and the result should be a number stored into a Characteristic called OnTime which will be in a Standard DSO and the cube above it. How can I achieve this? I would appreciate a step-by-step solution if possible. I am not proficient in ABAP and hence if there is coding involved, please provide the actual code too. I need it urgently. I will appreciate the help and points will be awarded.

Thanks in advance.

[bishwajit_das]

Hi,

Please try this FM:

DAYS_BETWEEN_TWO_DATES

you have other options also if you want..

DAYS_BETWEEN_TWO_DATES

LEAP_DAYS_BETWEEN_TWO_DATES

HR_SEN_CALE_DAYS_DATE

ISB_DAYS_BETWEEN_TWO_DATES

FIMA_DAYS_BETWEEN_TWO_DATES

FIMA_DAYS_BETWEEN_TWO_DATES_2

FIMA_LEAP_DAYS_BETWEEN_2_DATES

SD_DATETIME_DIFFERENCE Give the difference in Days and Time for 2 dates

Regards,

Bishwajit.