How to add more choices in dropdown for date fields in reporting? I want to add a new date condition like "last fiscal year" in my interactive filters?.

[HARI KISHAN GVS]

Hi Team,

I want to use date filters like 'last fiscal year', 'next fiscalyear', etc..

after i created the fiscal calender those options are automatically coming in reports date filter under Schedule (like in attached 'Example Screenshot' image) But those are not coming in  Interactive date filters.(like in attached 'OOB Interactive Date filter Options' image)

How can i add my fiscal date choices in Interactive date filters choices?

Thank you,

Hari Kishan.

[PaulSylo]

Hello Hari -

This required a tweak, pls go through this link this helps. I added using this link,

You need to go to system definition --> Business rules ---> search for "Get Date Filter Options for Date Filters" and go to advance and need to do the tweak. you can find more detail and how to tweak in this below KB article.

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0749822

Regards,

Paul

[Bhavya9]

Hello,

For some reason I couldn't open this KB article . So could you @HARI KISHAN GVS  please elaborate what you did to achive the solution as I have same requirement now.

Thanks in advance.