Qliksense does not auto detect timestamp as a date format ?

[claudialet]

 I have 2 date fields loading from Excel : 

Assign Dates: 

08/12/2019 10:56 AM

this is loaded as 

Timestamp(Timestamp#([Assign Date], 'MM/DD/YYYY hh:mm TT') ) AS [Assign Date],

Due Date 

43604

The Due Date is automatically recognized as a date field in  Date Picker extension as a date field but the other is not. 

I tried various formats with Date () and floor () but timestamp dates  09/24/2018 07:18 AM are not being detected by the Date Picker.

Any suggestions  ?

[andoryuu]

Try making your "TT" a lower case "tt".  Check out the formatting standards here.