Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to join two dates to calendar date?


Hi,

I have three dates and ids in two different tables. please see below and can anyone give me script of how to join these to calendar date?

Table1:
LOAD CustomerID,
     CustomerCode,
     Date(Floor(CustomerLogged))  as CustomerLogged,
   

FROM
[..\QVD\Data\Table1.qvd]
(qvd);

Table2:
LOAD
     ProcessID,
     CustomerID,
     Date(Logged,'DD/MM/YYYY')                                              as  Logged,
     Date(Processed,'DD/MM/YYYY')                                           as  Processed

FROM
[..\QVD\Data\Table2.qvd]
(qvd);

Thanks.

2 Replies
Not applicable
Author