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.