About Operators to Use with Date Fields

When you enter anything in the Criteria cell or the Or cell, the is equal to (=) operator is assumed at the beginning of the text unless a different operator is specified. For example, if you enter (#:D '2000-03-10') in the Criteria cell of a date field, Meridium Enterprise APM will assume that you want to return records where the value in that field is equal to March 10, 2000.

It is not necessary to enter the = operator at the beginning of the expression in a given cell. If you do not enter the operator, Meridium Enterprise APM will insert it automatically, but it will not be displayed. In addition, Meridium Enterprise APM inserts but does not display the text WHERE or HAVING before the beginning operator (either an implied = operator or an explicit alternate operator). This means that the SQL code will contain either a WHERE clause or a HAVING clause as a result of the text that you enter in the Criteria cell or the Or cell.

The following table provides examples of operators that you can use to manipulate values returned in date fields.

Note: If you use an expression to return records where the date is a certain number of days before or after some date, even if you do not specify a time along with the date, Meridium Enterprise APM will assume that you want to return records where the time is exactly 12:00:00 A.M. on that date. For example, if you enter the expression (#:D '1997-01-05') +1, the query will return records where the date is January 06, 1997, and the time is exactly 12:00:00 A.M.