Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Does anyone know how to set the following calendar extension up?
I have a date field called SCHED_DUE_DATE that has a time stamp with it but even when I just isolate the date using Date() and Date#() functions, no selection occurs. When I select a date the is no filter that occurs for that date.
Thanks in advance for any help
Try
date(floor(SCHED_DUE_DATE)) as SCHED_DUE_DATE
Date(SCHED_DUE_DATE) just formats as date but the number is still a timestamp
I just tried both of those but still I am having trouble selecting my date. The issue I think is that when I select a date on the calendar, qlik is not recognizing that I am making a selection and want it to filter by that.
In your extension it says it would take only DD/MM/YYYY format for date
Make sure you have same date format set for your SCHED_DUE_DATE
I do have that set but my table isn't recognizing a date selection from the calendar extension. Is there some code i can write in Data Handling that will help the table reference the variable that I set?