Custom date interactive filter issue

[sonu16]

I'm trying to add a custom date interactive filter to the home page so that user can select specific date they want to filter. I found the attached update set in community.

the custom interactive filter would look like the below it's working fine if the date format is yyyy-MM-dd but our instance is in MM-dd-yyyy. So it's showing no data available for filters when I try it in our instance.

Any suggestions on where to make changes in the attached?

Also I'm trying to add debug homepage filter to the home page but I din't find the option to add. How do I add Debug homepage filter?

Thanks

[sonu16]

pieter.goris

[tatianasp17]

I had the same issue. So, I updated the ui macro "interactive_date_filter" as below:

Replace this code '$[gs.getDateFormat()]' for 'yyyy-MM-dd' and the filter will work with any date format in your instance

[Abhishek Dixit1]

This solution works. 

[Akhilkumar2]

hi Sonu,

How did you created this kind of interactive filter

Regards,

Akhil