Date Picker Is Not Working

[metin_inksen]

Hi everyone, I'm an intern at a technology company and as a part of my internship process, I'm learning Qlik Sense.

I'm using Qlik Sense and I imported data from an Excel file. On this file, there is a date column named CreationTime but Qlik Sense does not recognize it as date so I manually change it, general to date. But on Date Picker extension, there is no date to select. Then, I used the following code but it didn't work again. 

Date(CreationTime, 'YYYY-MM-DD') AS CreationTime,

Would you please help me? Thanks in advance.

[abhijitnalekar]

Can you please try 

date#(string, dateformat) instead of only Date.

[metin_inksen]

I tried what you said but it didn't work. My date format is "SET DateFormat='YYYY-MM-DD';" if it will help to identify the problem.

[abhijitnalekar]

can you share the actual date format from the data?

[metin_inksen]

Of course, 2021-01-08 16:42:15.5783416 is the datetime format used in Excel file. I changed it from this to YYYY-MM-DD by data manager.

[abhijitnalekar]

Please try as below

date(Date#(datefield),"YYYY-MM-DD")

[metin_inksen]

Unfortunately this doesn't work either. I can't see any option on date field for date picker extension.