
Contributor II
2021-09-27
07:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Date Picker Is Not Working
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.
1,311 Views
6 Replies

Specialist II
2021-09-27
07:41 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you please try
date#(string, dateformat) instead of only Date.
Regards,
Abhijit
keep Qliking...
Help users find answers! Don't forget to mark a solution that worked for you!
Abhijit
keep Qliking...
Help users find answers! Don't forget to mark a solution that worked for you!
1,288 Views

Contributor II
2021-09-27
07:59 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
1,281 Views

Specialist II
2021-09-27
08:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
can you share the actual date format from the data?
Regards,
Abhijit
keep Qliking...
Help users find answers! Don't forget to mark a solution that worked for you!
Abhijit
keep Qliking...
Help users find answers! Don't forget to mark a solution that worked for you!
1,275 Views

Contributor II
2021-09-27
08:08 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
1,269 Views

Specialist II
2021-09-27
08:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please try as below
date(Date#(datefield),"YYYY-MM-DD")
Regards,
Abhijit
keep Qliking...
Help users find answers! Don't forget to mark a solution that worked for you!
Abhijit
keep Qliking...
Help users find answers! Don't forget to mark a solution that worked for you!
1,265 Views

Contributor II
2021-09-27
08:38 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Unfortunately this doesn't work either. I can't see any option on date field for date picker extension.
1,260 Views
