Skip to Content
0
Former Member
Jan 21, 2014 at 10:12 AM

date difference in correct calculation

26 Views

Hi Experts,

I am currently working on "0sr_mc02_q0006" delivery delays report in SRM.

Requirement:

To calculate the date difference between "Confirmation date" and "delivery date"

Issue:

This is a standard content report and a standard CKF in place

The date difference is getting calculated in correctly

eg:

PO No Material Confirmation date (C3) Delivery date(C4) Confirmed Quantity(C5) Date difference( C4-C3)

234189 M1 29.12.2013 03.01.2014 1EA 4

M2 29.12.2013 03.01.2014 1EA 4

M3 29.12. 2013 03.01.2014 1EA 4

Issue:

The date difference is getting summated at the query level as 12 days, but the original date difference is 4 days.

Please provide your valuable suggestions.

Regards,

Susheeth