Thank you for your feedback.
Form temporarily unavailable. Please try again or contact docfeedback@servicenow.com to submit your comments.
Versions
  • London
  • Kingston
  • Jakarta
  • Istanbul
  • Helsinki
  • Geneva
  • Store
Close

Values for date/time fields

Values for date/time fields

When you filter on fields of type date/time, such as the Created field on any task record, several time-related options are available, such as Today, This week, Last 3 months, and so on.

For example, at 12 P.M. on June 1st, a user in New York filters a list of incidents using the Created on Today condition. The resulting list shows all incidents created during the last six hours: between midnight (00:00:00) and the user's current time, noon (12:00:00), on June 1st. A filter for This week returns incidents created between the previous Monday at midnight to the current day and time.

A filter for Last 3 months returns incidents between midnight on the 1st of the month three full months ago and the current day and time. For example, if you choose the Last 3 months filter on April 15th, the results show records created since January 1st up until April 15. A filter for Last 12 months returns records created from midnight on the first of the month twelve months ago and the current day and time.

The at or before and at or after filters use midnight as a start or end point. For example, if you filter a list of incidents created [at or after] [Yesterday], the resulting list shows all incidents created at midnight yesterday or later. If it is Thursday, August 7, and you filter a list of incidents created [at or before] [Last week], the resulting list shows all incidents created at and before midnight on Sunday August 3, which is the end of last week.