How to set a date in a report

MatthewB9421455
Tera Contributor

I’m looking to create a report that will filter tasks that are within 3 days of being in their ‘planned end date’.

 

how would be best to write this criteria? There dosent seem to be an option for current date meaning I can’t do - ‘currentdate ’ is less than 4days before ‘planned end date’ .

 

is there a way to get a realtime date in the filter ? Or what would be the best workaround?

1 ACCEPTED SOLUTION

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @MatthewB9421455 

are you trying this way

 

AGLearnNGrow_0-1711543737901.png

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

View solution in original post

1 REPLY 1

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @MatthewB9421455 

are you trying this way

 

AGLearnNGrow_0-1711543737901.png

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************