Reporting on "oldest 5"

[ssoto]

How can I build a report that will automatically update to only show the "oldest 5" incident tickets?   I manually have to update the date to only show what I need.   This is the filter I've been using:

[harshinielath]

Hi

      You have to write the script that does the calculation of current date/time and opened date/time

there are methods to do this

Refer the glide date/time methods in wiki

GlideSystem Date and Time Functions - ServiceNow Wiki

datediff() or daysAgo()

[ssoto]

Ahhh ok thanks!

[ssoto]

And this will automatically set the date to show only the oldest 5 incident tickets?

[harshinielath]

Yup if you give the input from 'opened' field and current date/time.

Click like or helpful if it solved the issue