Help with Calendar Extension

[artempotsuray]

Does anyone know how to set the following calendar extension up?

Qlik Branch

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

[robert99]

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

[artempotsuray]

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.

[MK9885]

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

[artempotsuray]

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?