I want to take StartDate's First Time - StopDate's Last Time.

[Paknanarn23]

I want to take First Time of StartDate - Last Time of StopDate where KcePart1 WorkOrder1 is the same, but the layers don't have to be the same. What should I do?

[SajjaAshokVardhan]

Please try the below code.

ScanMV:

LOAD 

    DATE, 

     kcePart1, 

     WorkOrder1, 

     Layer, 

     StartDate,

     StopDate

FROM

[C:\Users\HP\Downloads\Paknanarn23_0-1691119306023.xlsx]

(ooxml, embedded labels, table is Sheet1);

Result:

load Distinct kcePart1,

WorkOrder1,

date(min(StartDate),'DD/MM/YYYY hh:mm:ss') as StartTime,

  date(max(StopDate),'DD/MM/YYYY hh:mm:ss') as StopTime

  Resident ScanMV 

  Group by kcePart1,WorkOrder1;

[Paknanarn23]

I want to take StartDate - Stopdate to find the Doentime value.