How to use relative date to screen out scheduled start data two weeks later

Wei_ Ling
Tera Guru

In the Field Service Management for Agent mobile:
For Work Order Task, display WOT with Scheduled Start on or before today + 2 weeks

eg: 
 - On 19 Oct, show WOT on or before 2 Nov
 - On 20 Oct, show WOT on or before 3 Nov

 

I am not familiar with the screening tool relative date, how can I configure it to meet my needs?

Wei_Ling_0-1666254483563.png

 

1 ACCEPTED SOLUTION

AnubhavRitolia
Mega Sage
Mega Sage

Hi @Wei_ Ling 

 

Please try below filter based on your sample examples:

 

AnubhavRitolia_0-1666266769011.png

 

Use 'Scheduled Start' instead of 'Planned Start Date' in your case.

 

 

Please mark this as correct answer and helpful if it resolved, or mark this helpful if this help you to reach towards solution.

Thanks
Anubhav Ritolia
ServiceNow Rising Star 2023

View solution in original post

2 REPLIES 2

Muhammad Khan
Mega Sage
Mega Sage

Try once with something like below.

Scheduled start     relative     before     14 Days from now

AND

Scheduled start     relative     on or after      today

AnubhavRitolia
Mega Sage
Mega Sage

Hi @Wei_ Ling 

 

Please try below filter based on your sample examples:

 

AnubhavRitolia_0-1666266769011.png

 

Use 'Scheduled Start' instead of 'Planned Start Date' in your case.

 

 

Please mark this as correct answer and helpful if it resolved, or mark this helpful if this help you to reach towards solution.

Thanks
Anubhav Ritolia
ServiceNow Rising Star 2023