Create Dynamic Filter for Incident Date/Time Fields

[JosephW1]

Hello, I wish to add a Dynamic Filter to all the date fields of the Incident table and have it selectable from the condition builder while building queries on the Incident table. Ex: Created, Opened, Resolved, Closed.

I have created a dynamic filter with the below configuration, but it still does not appear in the choice list in the condition builder when building a query for the Opened field on the incident table. What do I need to do to make it appear in the choice list for this field, please?

[Chuck Tomasi]

Have you tried putting in some script?

Create a dynamic filter option | ServiceNow Docs

[JosephW1]

I read that document before posting this but unfortunately I still am not currently able to solve this without intervention. I did already try putting in some script. I grabbed the only script I could find for an OOTB Date/Time field type Dynamic Filter - First Day of 2100 (Date and Time) - and popped it into another test Dynamic filter - didn't work, still not visible from the condition builder.

Can you, or someone else, make a Dynamic Filter for the Opened, Created, Resolved, & Closed fields on the Incident table, get it to show up in the condition builder, and then detail the steps you took, please? Thanks!

[JosephW1]

@Jaspal Singh Thank you Jaspal, you answered this question via your answer on the Dynamic filters not available for Date/Time field type - IS (dynamic) doesn't show up 4 days ago.

"Not all Operators are available for all fields. As of now there does not exists any functionality of dynamic filter. In your case I suggest you to use relative (is more than, is less than) to meet your requirement.

Refer link that has list of operators available per field type."

-Jaspal Singh

The dynamic filter operator is only available for Reference fields. Since Date/Time fields are not reference fields, the dynamic filter operator will not be available.

[Jaspal Singh · Accepted solution]

Great to know thread & other references are being referred before posting a question.

Glad to know it helped in some or other way.