Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
kdaniels-obrien
Partner
Partner

Date picker not working with my date field

Hi, 

I am having an issue with the date ranger picker extension.  I have a field called trueDate that has the format YYYY-MM-DDTHH:mm.  I have the line: date#(left(trueDate,10), 'YYYY-MM-DD hh:mm') as logicalDate 

in my load script to format date as YYYY-MM-DD to filter by those dates but the calendar does not recognize any dates (I can't select a date at all).  The line I used above gives me properly formatted data that I can see when I put trueDate in a table, it just doesn't work in the extension. 

I have read other threads about formatting issues with date range picker but I can't find a solution that works for me. 

Please help 🙂 

1 Solution

Accepted Solutions
kashyap
Partner
Partner

Hi

Try this

Date(date#(left(trueDate,10), 'YYYY-MM-DD hh:mm'),'YYYY-MM-DD') as logicalDate 

Hope this helps

Thanks

View solution in original post

2 Replies
kashyap
Partner
Partner

Hi

Try this

Date(date#(left(trueDate,10), 'YYYY-MM-DD hh:mm'),'YYYY-MM-DD') as logicalDate 

Hope this helps

Thanks

View solution in original post

kdaniels-obrien
Partner
Partner
Author

This worked thank you!