Limit results to yesterday, last week, or last year with the Date column drop down menu:
- To search for a specific MONTH and YEAR (for example July 2011) you could use any of the following:
july/2011
jul/2011
2011/july
2011/jul
jul/2011
2011/july
2011/jul
SPECIFIC DAY
To search for a specific date (for example July 2, 2011), you could enter any of the following in the Date/Time search column:
jul-2-11
july-2-11
2-jul-11
2-july-11
11-2-jul
11-2-july
In the above examples, dashes '-' and slashes '/' are interchangeable (for example, you could enter: jul/2/11). You can also enter the full year, 2011, in place of 11 (for example, you could enter: jul-2-2011)
july-2-11
2-jul-11
2-july-11
11-2-jul
11-2-july
In the above examples, dashes '-' and slashes '/' are interchangeable (for example, you could enter: jul/2/11). You can also enter the full year, 2011, in place of 11 (for example, you could enter: jul-2-2011)
BETWEEN SPECIFIC RANGES
For date range searching, the dates entered in the Date/Time search column MUST be in the format: yyyy-mm-dd or yyyy-mm (whichever is applicable)
- As an example, to search for dates from July 20, 2011 to July 29, 2011, enter:
2011-07-20..2011-07-29
BETWEEN 2011-07-20 AND 2011-07-29
BETWEEN 2011-07-20 AND 2011-07-29
In these examples, dashes '-' and slashes '/' are interchangeable.
- To search between months (i.e. between July 2011 and August 2011 inclusive), enter:
2011-07..2011-08
BETWEEN 2011-07 AND 2011-08
BETWEEN 2011-07 AND 2011-08
Dashes '-' and slashes '/' are interchangeable with the above examples.
- To search for items occurring after a specific date, enter:
>2011-07-19
AFTER 2011-07-19
AFTER 2011
AFTER 2011-07-19
AFTER 2011
Again, dashes '-' and slashes '/' are interchangeable.
0 Comments