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.
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.
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!
cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
