It is possible to search number fields in iSearch Analytics for exact values or for a range of values, e.g., awarded dollars above an amount or publication years between two dates.
To search multiple years, place the minimum and maximum within square brackets and use "TO."
For example:
fy:[2010 TO 2015]
To search an open-ended range, use an asterisk as a wildcard.
For example:
fy:[2010 TO *]
The correct format for date fields containing day, month, and year is year-month-day separated by dashes.
For example:
projectPeriodStartDate:[2004-01-01 TO 2004-12-31]
Note the square brackets tell the tool to include the start and end values. The same search with curly brackets will exclude the start and end points.
For example:
projectPeriodStartDate:{2004-01-01 TO 2004-12-31}
This search will return records between January 2nd, 2004 and December 30th inclusive, i.e., it’s the same as searching projectPeriodStartDate:[2004-01-02 TO 2004-12-30].