Reports using Date as Dynamic - Today, This Month , This Week, This Year, This Quater

riagarwal · ‎07-30-2023

Please assist, as there is no option that I can find that. As I want to create report so that I can find the work that is assigned to me looking for my this week, month work.

Date to be dynamic, so that I don't have to edit it every time, I want to see the report.

Thanks

Ritesh Aggarwal

Sagar Pagar · ‎07-30-2023

Hi @riagarwal,

What you have started or any issues?

You can create a report on Task table with conditions as Task type is Incident or Problem or Change requests or Requested items or Catalog tasks.

For Date as dynamic - we already have options/ filter...

Today, This Month , This Week, This Year, This Quarter etc.

For reference, I took example of This week..

Take a look at old thread: How to build a report that shows all work assigned to me

If my response helps to solve your issue. Kindly mark it as helpful & correct. It will be helpful for future readers.
Thanks,
Sagar Pagar

The world works with ServiceNow

View solution in original post

Sandeep Rajput · ‎07-30-2023

@riagarwal Did you check the filters available on any date field. The filters you are looking for are already available Out of the box.

View solution in original post

AndersBGS · ‎07-30-2023

Hi @riagarwal

To create a report that dynamically shows your work for the current week and month without the need to edit it every time, you can follow these steps:

1. Create a new report in ServiceNow:
- Navigate to "Self-Service" -> "Reports" -> "Create New".
- Select the table that contains the work items (e.g., the incident table, change_request table, or any other table you want to report on).

2. Set the filter conditions for the report:
- Add a filter for "Assigned to" field and set it to your user.
- Add a filter for the date field (e.g., "Opened" or "Created on" field, depending on your requirement).

3. Make the date filter dynamic for the current week:
- Edit the date filter condition, and set the "Type" to "Dynamic" or "Relative".
- Set the "Relative Date" to "Start of week".

4. Make the date filter dynamic for the current month:
- Create a new filter condition for the date field.
- Set the "Type" to "Dynamic" or "Relative".
- Set the "Relative Date" to "Start of month".

5. Save the report with a suitable name.

Now, when you run this report, it will automatically show you the work items that are assigned to you and were created within the current week and month, respectively, without the need to edit the date filter each time.

Please note that the steps may slightly differ based on your version of ServiceNow and access permissions, but the general approach remains the same.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

View solution in original post

riagarwal · ‎07-31-2023

Thanks for your replies really appreciate!!

Just one more question, I want to create a report on task which are scheduled for Specific days for example, every Saturday or Sunday.

As we have PROD updates that are scheduled on these days. with the current date options, I can select week, month, etc.. however how do I select Particular Days

Thanks