To find values that are | Use this operator | Examples |
Less than a specified value | < | <40 <9/7/2019 <M |
Less than or equal to a specified value | <= or ≤ | <=95129 ≤05:00:00 <=M |
Greater than a specified value | > | >95129 >9/7/2019 >M |
Greater than or equal to a specified value | >= or ≥ | >=100 >=9/7/2019 ≥8:00 ≥M |
Within the range you specify | .. or ... (two or three periods) | 12:30...17:30 1/1/2019..6/6/2020 A...M Mon..Fri |
Within the sub-range you specify | {..} or {...} (two or three periods) | 7/{1...15}/2019 {1..3}/{10..16}/2020 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/*/2019 2/* 2019 *:30 PM |
To find dates | Type this in the field |
In June 2019 | 6/2019 |
From July 2019 through October 2020 | 7/2019...10/2020 |
That occur on a Friday | =Friday |
From the 10th through the 16th of October or November 2019 | {10..11}/{10..16}/2019 |
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 2019 | 5/2019 7 PM |
That occur on a Monday in 2020 | =Mon 2020 |
From the 10th through the 16th of November 2020 and from 3:00 PM to less than 6:00 PM | 11/{10..16}/2020 {3..5} PM |