Date picker not working with my date field

[kdaniels-obrien]

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 🙂 

[Kashyap_R · Accepted solution]

Hi

Try this

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

Hope this helps

Thanks

[kdaniels-obrien]

This worked thank you!