How to Create a report to show records that will expire within 30 days from current date?

[Anand Shukla]

Hello Experts,

I need to create and send an report where record that will expire within next 30 days from now.

Expire date is a type of glide_date type. On the report I am not able to see the on or before operation in relative.

Please suggest how to achieve this?

Thanks

[Rahul Kumar17]

Hi Anand,

To create a report that shows records expiring within the next 30 days from the current date, you can use ServiceNow's reporting capabilities and apply the necessary filter conditions. Here's how you can achieve this:

1. Go to the ServiceNow instance and navigate to the appropriate module for creating reports (e.g., Reports > Create New).

2. Choose the table or module that contains the records with the "Expire date" field.

3. Set up the basic configuration for your report, including the columns you want to display.

4. Add a filter condition to display only the records that expire within the next 30 days. To do this:

   a. Click on the "Add Filter" button.

   b. Select the "Expire date" field from the available fields.

   c. Choose the appropriate operator based on the type of "Expire date" field. If it is a GlideDate field, select the "On or after" operator.

   d. Use the dynamic filter value option to enter the current date by selecting "GlideDate" > "Get date" > "current".

   e. Click on the "Add" button to add the filter condition.

   f. Click on the "Add Filter" button again.

   g. Select the "Expire date" field from the available fields.

   h. Choose the "On or before" operator.

   i. Use the dynamic filter value option to enter the date 30 days from now by selecting "GlideDate" > "Get date" > "current". Then, in the "Operations" section, add the value "+30d" to indicate 30 days in the future.

   j. Click on the "Add" button to add the filter condition.

5. Adjust any additional report settings and formatting options as desired.

6. Save the report and run it to see the records that will expire within the next 30 days.

By setting up the filter conditions as described above, the report will display only the records where the "Expire date" field falls within the range from the current date to 30 days in the future.

Thanks,

Rahul Kumar