Using Dates in Filter Expressions

In some filter expressions, such as those that define dynamic groups, you can use dates as selection criteria by specifying today's date plus an offset in days. For example, the expression:

SELECT DISTINCT NODENAME FROM HWUPDATE WHERE CREATEDATE < #$MM/DD/YY(-31)$#

identifies any Clients for which the latest inventory data is more than 31 days.

You can enter a date variable in any of the following formats:

Format

Example

$MM/DD/YY(nn)$

01/31/99

$MM-DD-YY(nn)$

01-31-99

$MMDDYY(nn)$

013199

$DD/MM/YY(nn)$

31/01/99

$DD-MM-YY(nn)$

31-01-99

$DDMMYY(nn)$

310199

$DD/MMM/YY$

31/Jan/99

$DD-MMM-YY$

31-Jan-99

$DDMMMYY$

31Jan99