Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Zaidan_as
Creator
Creator

Date picker doesnt recognise date data from load editor using SQL

Hello Qlik Expert!
Sorry if my english is bad.

So as you can see in the subject, right now I want to use the Date Picker extension from Qlik Dashboard Bundle. But when I see in the date field selection, there is no field that I can choose. You can see image below for the proof.

Zaidan_as_0-1656649424733.png

Then I see some another question from Qlik User that have the same problem as me, but all of them load the data not using the SQL like me. 
So for the SQL it self, this is the illustration of it 

Zaidan_as_1-1656649528269.png

Zaidan_as_4-1656649642498.png

 

In the auto generated section, this field is already tagged as the Date

Zaidan_as_2-1656649565753.png

And I see some reference that I must change the format from my code as like the calendar picker format 

Zaidan_as_3-1656649623241.png

but the result is the same. there is no selection for the date field.

So any suggestions guys ?

Labels (3)
1 Solution

Accepted Solutions
Zaidan_as
Creator
Creator
Author

Sorry i thought i already deleted this question.

I already solved this problem. 

As you can see in my SQL script, 
I comment the code
Conver(Date, a.CreatedOn)
However this code is the solution for my problem.


This is the real answer for me. my bad because I didn't check it first. 

Btw thanks for your reply.

View solution in original post

2 Replies
vinieme12
Champion III
Champion III

try tagging the field as date in your script

 

Tag "Output Time" with '$date';

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Zaidan_as
Creator
Creator
Author

Sorry i thought i already deleted this question.

I already solved this problem. 

As you can see in my SQL script, 
I comment the code
Conver(Date, a.CreatedOn)
However this code is the solution for my problem.


This is the real answer for me. my bad because I didn't check it first. 

Btw thanks for your reply.