Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Date field not recognized by date picker extension ?

 Here is the  load script for the date field 

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

This field does not automatically show up in the Date Picker extension.

I tried date ( floor( [Date field])) in the script  but that does not work also. 

In the Excel file all the values are formatted as :  11/21/2018 01:15 PM

How do I eliminate the  01:15 PM  and make the Date Picker pick up the field ?

 

Any ideas ?

2 Replies
Highlighted
Partner
Partner

Check your data format, must be the same at properties from extension:

calendar.png

Support your colleagues. Remember to "like" the answers that are helpful to you and flag as "solved" the one that helped you solve. Cheers.
Highlighted
Contributor III
Contributor III

 No  the date field is still not being recognized by the date picker