Date Formatting

[wdchristensen]

When I add a date field to a filter pane in Qlik Sense it shows up in an undesirable format (yyyy-mm-dd). My data is being pulled from date fields in SQL Server it formats the data in  format? It is almost like I am inadvertently converting the date to a string before it enters my application.  How can I get my filter to show the date as I intend to see it (m/d/yyyy) without converting it to a string?  Any help would be appreciated. 

[dwforest]

Are you trying to get the date part from a datetime field? date and timestamp are different in Qlik (and per your original post, if the date format and the timestamp format do not match the data it will make it a string).
To get the date from a timestamp, floor() the value. Dates/Timestamps in Qlik are dual value a number and string display. The number to the right of the decimal is time, so floor() essentially makes it midnight (00:00:00.000).
it is is still not working, example of your script and data is needed.

[wdchristensen]

Thanks dwforest for your help. 

https://community.qlik.com/t5/Qlik-Sense-App-Development/SET-DateFormat-YYYY-MM-DD-doesn-t-recognize...