To find values that are | Use this operator | Examples |
Less than a specified value | < | <40 <9/7/2014 <M |
Less than or equal to a specified value | <= or ≤ | <=95129 ≤05:00:00 <=M |
Greater than a specified value | > | >95129 >9/7/2014 >M |
Greater than or equal to a specified value | >= or ≥ | >=100 >=9/7/2014 ≥8:00 ≥M |
Within the range you specify | .. or ... (two or three periods) | 12:30...17:30 1/1/2014..6/6/2015 A...M Mon..Fri |
Within the sub-range you specify | {..} or {...} (two or three periods) | 7/{1...15}/2014 {1..3}/{10..16}/2015 12:{30..45} {7...9}:15 PM |
Based only on certain date or time components such as month, year, or minutes (see more examples below) | * or type nothing for each component you don’t want to specify | 3/*/2014 2/* 2014 *:30 PM |
To find dates | Type this in the field |
In June 2014 | 6/2014 |
From July 2014 through October 2015 | 7/2014...10/2015 |
That occur on a Friday | =Friday |
From the 10th through the 16th of October or November 2014 | {10..11}/{10..16}/2014 |
That occur on March 1st between 1868 and 1912 in the Japanese Emperor Year era of Meiji | m*/3/1 |
That occur on December 31st between 1930 and 1940 in the Japanese Emperor Year era of Showa | S{5..15}+12+31 |
To find times | Type this in the field |
In the 3 o’clock hour, not including 4:00 PM | 3 PM |
Between 8:00 AM and 8:59:59 PM | 8 AM...8 PM |
In the morning | AM |
Any of the times 4:30, 5:30, and 6:30 PM | {4..6}:30 PM |
To find timestamps | Type this in the field |
In the 3 o’clock hour today | // 3 PM |
In the 7 o’clock hour in May 2014 | 5/2014 7 PM |
That occur on a Monday in 2015 | =Mon 2015 |
From the 10th through the 16th of November 2015 and from 3:00 PM to less than 6:00 PM | 11/{10..16}/2015 {3..5} PM |