Date format problem

[GuillaumeRUE]

Hello,

I created those two tables :

MISSION_2:
LOAD ID_ORDRE, 
     AGV,  
     Timestamp(DATE_ORDRE,'DD/MM/YYYY hh:mm') as Id_Date_AGV,
     TYPE_ORDRE, 
     POIDS_TRANSPORTE

CalendarTemp:
LOAD DayStart(TimeStamp($(varMinDate) + (RecNo()/60/24) + (IterNo() -1))) AS AddedDate, // Use this one as date 
     TimeStamp($(varMinDate) + (RecNo()/60/24) + (IterNo() -1),'DD/MM/YYYY hh:mm') AS AddedTimeStamp
AUTOGENERATE 1339 WHILE Num($(varMinDate) + IterNo() -1) <= Num($(varMaxDate)); 

TIME_CALENDAR:
LOAD 
     AddedTimeStamp as Id_Date_AGV,
     Date(Floor(AddedTimeStamp)) as Date_AGV,
     Year(AddedTimeStamp) as Annee,
     Month(AddedTimeStamp) as Mois,
     Day(AddedTimeStamp) as Jour,
     Week(AddedTimeStamp) as Semaine,
     Hour(AddedTimeStamp) as Heure,
     Minute(AddedTimeStamp) as Minute
Resident CalendarTemp
Order By AddedTimeStamp ASC;

  But not all data from MISSION_2 is linked to the calendar, only few rows, any idea?

[m_woolf]

I think you need:

Date(Floor(DATE_ORDRE)) as Id_Date_AGV,

[Brett_Bleess]

Couple of Design Blog posts for you that may help if you are still working on things:

https://community.qlik.com/t5/Qlik-Design-Blog/The-Master-Calendar/ba-p/1471527

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

Regards,
Brett