Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
AnitaTrimukhe
Contributor II
Contributor II

Date Picker not recognizing date field

Hi All,

I have june 2019 enterprise web version installed.
I have two dates 'Date1' as datetime and 'Date2' as date in sql. Qlik sense has recognized 'Date1' as timestamp.  I am using date picker it is recognizing only 'Date2' and not 'Date1'.

I tried converting it in script editor using  Date(Date1), Date#(Date1), Dayname(Date1), date(floor(Date1)) still date picker is  not recognizing  'Date1'.  I Also tried converting 'Date1' in SQL and then fetching in Qlik sense still 'Date1' not available in date picker data field.

Labels (2)
3 Replies
eliran
Creator III
Creator III

Hi,

Basicaly, if you use the script reload, you can tag fields as date, and that's suppose to identify it within the range picker.

The syntax is TAG FIELD <fieldname> with $date;

 

Please try and update.

Eliran.

 

AnitaTrimukhe
Contributor II
Contributor II
Author

Thank you Eliran,

This is also not working. I am Still getting only 'Date2' in picker.

eliran
Creator III
Creator III

Hi,

Basicaly, if the date having the same date fomat in the model, and you tag it as date, you should see it in the drop down list.

However there is an option to bypass it, there is an 'advanced setup' option under the field menu.

When choosing 'ON', you can pick any field you want using the expression tool.

There is a little catch, In some versions you need to have atleast one field to pick from before this feature is displayed.

 

Eliran.