Instructions:

  1. Enter an expression into the Date Criteria Box
  2. Click the Test button below to show what your criteria evaluates to right now.
  3. Click OK to close this dialog and use the current criteria you've entered.
  4. Click Cancel to close without changing your Query date field.


Standard date/time
Y=year, m=month, d=day, H=hour, i=minute, s=second. Use slash (/) for date delimiter, colon (:) for time.
Ordinal names / numbers
[first - twelfth = 1 - 12] - but not the word "second" !
Special words
tomorrow, yesterday, ago, fortnight, now, today, day, week, month, year, hour, minute, min, second, sec - add "s" for plurals
Day and Month names
sunday - saturday, sun - sat, January - December, Jan - Dec