2,299
edits
Changes
→Search options
* '''Last Year''' - returns records that have a date value in the selected field of the previous year from the current year.
* '''This Year''' - returns records that have a date value in the selected field of the current year.
* '''This Month '''- returns records that have a date value in the selected field of the current month.
* '''Last Month '''- returns records that have a date value in the selected field of the previous month from the current month.
* '''Within the next X days '''- returns records that have a date value in the selected field that falls within the entered variable amount of days ''from'' the current day.
* '''Within the past X days '''- returns records that have a date value in the selected field that falls within the entered variable amount of days ''before ''the current day.
* '''X days before today '''- returns records that have a date value in the selected field that is exactly the entered variable amount of days ''before'' the current day.
* '''X days after today '''- returns records that have a date value in the selected field that is exactly the entered variable amount of days ''after ''the current day.
'''Note: '''For date fields using a variable amount (i.e. '''X days'''), enter your preferred value in the '''Value '''field next to the ''''''date field. 5. Search Term field: field to enter the value to be searched for in the selected Field. If the field has predefined options (eg. a Select One - Combo Box), you will be presented with a list of the options, from which you can select as many as you would like, one at a time.
