On December 17, 2015, we upgraded to Sierra 2.0 Service Pack 3. With that upgrade, we have been able to resolve some outstanding issues, as well as add some new features.
One of the most useful added features is the ability to search in Create Lists using relative dates. So, for example, say you want to periodically query for a list of new titles by subject matter or call number that were added in the last month. Before, while you could save the query and use it again and again, you would have to manually change the date range each time. Now you don’t have to do that–because the relative date will automatically search by the range you define. Nifty.
Here is are the new relative date options and the keyboard shortcut that accompanies each one:
T (equals today)
- Retrieves records whose specified DATE field is equal to the day on which the search is run.
Y (equals yesterday)
- Retrieves records whose specified DATE field is equal to the day before the search is run.
V (within last week)
- Retrieves records whose specified DATE field falls within the previous calendar week (Sunday – Saturday).
M (within last month)
- Retrieves records whose specified DATE field falls within the previous calendar month.
A (is this many days ago)
- Retrieves records whose specified DATE field is equal to the specified number of days before the date on which the search is run.
B (is this many weeks ago)
- Retrieves records whose specified DATE field is equal to the specified number of weeks before the date on which the search is run.
C (is this many months ago)
- Retrieves records whose specified DATE field is equal to the specified number of months before the date on which the search is run.
