Date Searching Syntax
The DM administrator sets the date format order (DMY, MDY, or YMD). However, you can change this order on the Date format field on the Options page.
Assuming your site uses the format MDY, you can enter any of the following for the date February 25, 2014:
-
2-25-14
-
2-25-2014
-
2/25/14
-
2/25/2014
The DM Classic Webtop offers enhanced date searching capabilities that use these conventions:
-
%today represents today's date.
-
MINUS allows you to subtract a number of days from the specified date.
-
TO allows for a range of dates.
In the following examples of enhanced date searching:
Example 3-1: Searching Examples
-
To locate documents created between two sets of dates, enter:
date TO date
For example, 10/21/2014 TO 12/27/2014
-
To locate documents created in the last 30 days, enter:
%today MINUS n TO %today
For example, %today MINUS 30 TO %today
-
To locate documents created during the 10 days prior to a specified date, type:
date MINUS n TO date
For example, 10/21/2014 MINUS 10 TO 10/21/2014
-
To locate documents created between the specified date and the current date, type:
date TO %today
For example, 10/21/2014 TO %today
| |
|
|
Note:
If the Search button is clicked when a date or date search operator has been entered with an improper format, the warning Date Range: 'xxx' is not a valid date expression (where 'xxx' identifies the element of the search expression that contains an error) will appear in a dialog box. Click the OK button to return to the Search Page and correct the error. |
| |
Top of page
