Difference of dates

[Anonymous]

Hi,

I am attaching the application and suggest me on the same   

[Anonymous]

Hi SALTO,

Thnaks for your suggestion,

but it is not working ...

could you kindly go through the new data sheet and let me know

[salto]

Hi,

when you have read both excel files in tables First and Second, you need to rename and change the format of the field Job History Actual Start Timestamp like this:

TempSecond:

load *,

date(left([Job History Actual Start Timestamp],10),'MM/DD/YYYY') as CalendarDate Resident First;

drop table Second;

This way you have a relation between both fields.

[#4 · Accepted solution]

Hi John,

Please see attached,

[MK_QSL]

time:

LOAD Name,

     [Start Timestamp],

     Date(Floor(Timestamp([Start Timestamp]))) as StartDate,

     [End Timestamp],

     Date(Floor(Timestamp([End Timestamp]))) as EndDate,

     Status

FROM

Rank.xlsx

(ooxml, embedded labels, table is time);

Race:

LOAD RaceTime,

     Rank

FROM

Rank.xlsx

(ooxml, embedded labels, table is Race);

Inner Join IntervalMatch(RaceTime) Load StartDate, EndDate Resident time;

Join (time) Load * Resident Race;

Drop Table Race;