I want to generate a report on task table which will exclude weekends and which has been updated only before 2 days

Go to solution
Swarnarghya Gho
Giga Contributor

‎07-02-2019 07:40 AM

I want to generate a I want to generate a report on task table for one group (task type = catalog task)  which will exclude the updates made on weekends and which has been updated only before 2 days. Suppose today I am running the report, it will show the records which has been updated before 2 business days i.e. before 28th June.It should not show records updated on 28th June, weekends and 1st July.

0 Helpfuls
  • 1,610 Views
1 ACCEPTED SOLUTION

Go to solution
Ankur Bawiskar
Tera Patron
Tera Patron

‎07-02-2019 07:48 AM

Hi Swarna,

so you can try this; see screenshot below and let me know

find_real_file.png

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur

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

View solution in original post

Preview file
148 KB
5 REPLIES 5

Go to solution
Ankur Bawiskar
Tera Patron
Tera Patron

‎07-09-2019 11:09 PM

Hi Swarna,

Any update on this?
Can you mark my answer as correct, helpful if you were able to achieve the requirement. This helps in removing this question from unanswered list and helps users to learn from your thread. Thanks in advance.
 
Regards
Ankur

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