Date Picker not recognizing date field

[AnitaTrimukhe]

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.

[eliran]

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]

Thank you Eliran,

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

[eliran]

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.