Relative date searching in Create Lists

The last Sierra upgrade introduced some new functionality to Create Lists. You can now select ‘relative dates’ when you are searching on any date field.

What does this mean? With ‘relative date’ searching, you don’t have to enter a specific date (e.g. 14/03/2016), you can choose to search for a date according to its position relative to today.

For example if I want to run a daily review file to find items edited that day, without relative date searching I would need to manually change the date to todays date every time I run the file. With ‘relative’ date searching I can create a saved search that looks for items edited ‘today’ and the actual date will automatically change to todays date as the review file runs.

The strategy below will find all bib records created or updated ‘today’ or ‘yesterday’ – no need to enter actual dates.

saved search today

The new options available for relative date searching are as follows:

relative date selection

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.

 

Advertisements
This entry was posted in Create Lists, Sierra and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s