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