Instructions:
- Enter an expression into the Date Criteria Box
- Click the Test button below to show what your criteria evaluates to right now.
- Click OK to close this dialog and use the current criteria you've entered.
- 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
|