Date Picker not allowing date field to be used.

[JohnnyM1]

Hi All,

I need help setting up my date picker. I have read multiple forms and tried to follow everything as far as formatting my date so the date picker would recognize the date(DateFloor, Date, $Date). My date is recognized as a date field in Qlik sense but the picker just is not liking something. The only thing that I am guessing is causing an issue is there are two testing dates('7/7/7777' and '9/9/999'). Not sure what else I can do to get this date picker to work. 

[Or]

I believe there are certain limitations within Qlik on what gets tagged as a date, and one or both of those dates probably doesn't fit. I'd suggest using more "Reasonable" test dates, but you could force the issue by using e.g.

Tag FIeld DateFloor as '$date';

in your script.

For a longer explanation, see:

https://community.qlik.com/t5/App-Development/Date-is-not-appearing-as-date-field-in-datepicker/td-p...

[Lech_Miszkiewicz]

Tagging field as a date is one thing, second thing is that date field may be loaded as text. 

I suggest checking what are the tags for this field and ensure that it is numerical/date tag. If not during load you would need to use Date#() function to convert text to date.

Note that Date#() is not the same as Date() function! 

cheers!

[JohnnyM1]

Update:

Changed the SQL date to pull only 2015 through today before the QVD was loaded. This resolved the issue.