3.5. Using dates in searches Previous topic Parent topic Child topic Next topic

A number list pages allow you to search for items by date. You will see “date from” and “to” fields. For example, on the List Users page, you can search by the “Valid from” date. In these kind of date searches, you can limit the date range searched by entering a start date/time and/or an end date/time. If you enter neither the start nor the end date, then all the matching dates will be listed.
The dates and times you enter may be any of the supported date/time formats. See Entering dates and times.

Table 3. Example date ranges in searches

date from to Meaning
   
All dates
now  
Any time from right now
  now
Any time up until right now
  1 week
Any time up until midnight at the beginning of the day 1 week from today
1 d ago 1d
Any time from midnight at the beginning of yesterday to midnight at the end of today
1/1/99 tod 12:00
Any time from midnight at the beginning of January 1 1999 to midday today
now 1y
Any time from right now to 1 year from now
tod 8:00 tod 10:55 Any time from 8 am today to 10:55 am today.
tod tom
Any time today (i.e from midnight at the beginning of today to midnight at the end of today)