Date Format not Working

[bbergstrom]

In Qlik Sense we have a date field where the data is stored as yyyy-mm-dd and it needs to be converted to mm/dd/yyyy.  I tried using the following:

Date(Date#(DateEnteredSurplus,'yyyy-mm-dd'),'mm/dd/yyyy')

This formats the date correctly in the Qlik Hub, 04/29/2016, but when I export the table it looks like this in Excel:

/29/2016

Clicking on the cell reveals this value: 01/29/2016 12:04:00 AM

Can someone help me understand why this is not exporting correctly. 

[Vegar · Accepted solution]

Format mm is minute. Format MM is month.

Try

Date(Date#(DateEnteredSurplus,'YYYY-MM-DD'),'MM/DD/YYYY')

[sergio0592]

In addition, take a look at this post :

https://community.qlik.com/t5/Qlik-Design-Blog/The-Date-Function/ba-p/1463157