Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Date filter condition in table

preethigovi
Tera Contributor

Hi Team,

 

I want to add filter in HR profile for last day of work field  , so don't  get data for prior to 30 days before current date.

How to achieve this?

1 ACCEPTED SOLUTION

@preethigovi 

you can use this filter condition

  1. [Date Field] [on or after] [Relative] [30 days ago]
    
Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

7 REPLIES 7

Ankur Bawiskar
Tera Patron
Tera Patron

@preethigovi 

your requirement is not clear.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Hi @Ankur Bawiskar ,

Example, last day of work has value 1.11.24 and today is 17.12.24---> Means its prior 30days I don't want this data.

 

Last day of work is 22.11.24 and today is 17.12.24--> which is not prior 30 days I need this data which is not prior than 30 days

 

I need to add this filter to trigger notification

@preethigovi 

you can use advanced notification condition and compare the dates

what script did you start with and how are you using it?

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

As of now I didn't start, we have one notification triggering there I have to check this filter not prior 30 days.

preethigovi_0-1734410987998.png