Perform Date Range Searches

Limit results to yesterday, last week, or last year with the Date column drop down menu:

Date_Range.png

  • 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 


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) 


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

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
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

Again, dashes '-' and slashes '/' are interchangeable. 
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk