Options for date searches
Contents
Date fields have calendar display and number of options. Wildcard characters, e.g. * or ?, are not allowed.
To display the calendar, click the calendar icon "15".
Alternatively, click in the Show Calendar box and then enter the date according to your locale settings.
To move to the previous month, click 3in the month line. To move to the next month, click 4. To display the list of months, click the month year, e.g. January 2010, and this changes the display to the list of months. Click to select the month you want.
To move to the previous / next year, click 3or 4 in the year line. To display the range of years, click the year line, and then click to select the year you want.
Date options
Option |
Matches the records which in the chosen field contain |
none |
Any date (don't filter by date) |
On |
The specified date/time |
Today, Yesterday, Tomorrow |
Today's, yesterday's or tomorrow's date |
This year, month, week |
The current year, month, week |
Last years, months, weeks, days, hours |
The past year, month, week, day, hour. |
Next years, months, weeks, days, hours |
The future year, month, week, day, hour. |
Before |
a date earlier than specified date. |
After |
a date later than specified date. |
Between |
a date/time later than the first specified date/time and earlier than the second specified date/time, including elements with date less or equal to 'to' condition if no hour, minute, second is specified |
Last minutes and day of week are currently not implemented.