Date range picker Dashboard extension not working

[tamas_kiss]

Hello,

I would like to ask you help with the Date Range Picker Dashboard Extension.

The extenension recognize my date field but nothing happens if I select a range or a date it does not filter the report, nothing happens. 

The format of the field is MM/DD/YYYY, which is not the default in my region. Do I need to set up this seperately in the extension? 

Thanks for your help in advance,

[tamas_kiss · Accepted solution]

I have found the solution.

Just for others with same problem. The Date picker was not able to handle the format different from the default (despite it was defined in the code). 

The solution was to create a second date field in the Master calendar in the default formar and set the Date Picker to use this field. Maybe it is nt the most elegant way but working.

[brichnma]

Hi,

I have the same problem you had and I don(t really understand your solution.

Can you please explain a bit more?

What do you mean by the default format? 

My format of the date field is dd/mm/yyyy  hh:mm:ss

And I have also an auto calendar that formats this date to dd/mm/yyyy

Many thanks

[tamas_kiss]

what is the default date format in the windows server?

For me, I had to use the Hungarian format YYYY. MM. DD

With this filed it is working for me.

[brichnma]

Thank you for your reply.

I have dd-MM-yy format in my windows server (see image). But I don't have in the options the format you have..

How can I use the right format in Qlik in this case please?

Regards,

[tamas_kiss]

For me this option does not worked. 

I added a new date filed in my data model with the date function. 

https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/Scripting/Formatting...

[brichnma]

Thank you again for your help

I finally used date([Calendar.Date],'DD/MM/YYYY') since the extension uses this format.

And it works well.

[SoftUser]

Could you please clarify where did you made those changes ? 

[tamas_kiss]

I have simply added a new filed to my master calendar in the data model where I have converted the date format with the DATE function

[SoftUser]

sorry to bother you...can you please attach a screenshot what you have done to the data model.