Date Picker Filter in dashboard

[jasonafs]

Hi everyone,

I'm trying to to put a date filter in a dashboard that contain some reports. I want to have a date picker.

Can someone help me to find a way to do this ?

(sorry for my english);

thx! 

[suvro]

If you have Performance Analytics Premium license you can go for interactive filters. It can be created using date time fields

[jasonafs]

Yes, im trying to use interactive filters, but i dont find the way to put a calendar picker that user can pick a date to filter report.

If i understood correctly, we must predefine the dates in advance with date time fields. I would like the user to be able to choose a specific date. I want to use input date html for example. Thx for your time 

[SanjivMeher]

We had similar requirements. But unfortunately, there is no option to in dashboards to provide a date picker as filter. There are few custom solutions which are mentioned below, but i find them buggy and could be difficult to maintain in future.

https://www.servicenow.com/community/platform-analytics-forum/how-to-create-a-date-range-interactive...

https://www.servicenow.com/community/platform-analytics-forum/date-range-filter-in-a-dashboard/m-p/1...

[jasonafs]

Maybe i have find a way!

So i use an input date html, and on the onChange Function i retrieve the date and i concat this date in this querys :

sys_created_onON2022-10-14@javascript:gs.dateGenerate('"+ date +"','start')@javascript:gs.dateGenerate('"+ date +"','end')"

And it seems that it work, in my dashboard i select a date and the good data are display! Now i have to find a way to create a between date filter. What do you think about this ?