topic Date Picker not allowing date field to be used. in Integration, Extension & APIs

Date Picker not allowing date field to be used.

JohnnyM1 — Mon, 16 Sep 2024 19:44:35 GMT

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.

Re: Date Picker not allowing date field to be used.

Or — Mon, 16 Sep 2024 20:13:09 GMT

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/1824187

Re: Date Picker not allowing date field to be used.

Lech_Miszkiewicz — Mon, 16 Sep 2024 23:20:27 GMT

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!

Re: Date Picker not allowing date field to be used.

JohnnyM1 — Tue, 17 Sep 2024 17:50:04 GMT

Update:

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