Most date fields contain a real absolute date. If not, they should contain the Windows Client standard null date or its standard invalid date. You can filter for these in various ways.
To find null dates, compare a date field to the word None. For example, you can use the following expression to find all data sets without expiration dates:
'Expire Date' = None
Testing against Gregorian date 00Jan1900 or Julian date 1900000 achieves the same results.
To find invalid dates, compare against the word Invalid. For example, you can use the following expression:
'Last Use Date' = Invalid
Testing against Gregorian date 99Dec2155 or Julian date 2155999 achieves the same results.
To compare against real absolute dates, you can enter a test date in the Gregorian (ddMONyyyy) or Julian (yyyyddd) format (z/OS only) as shown in the following example:
'Create Dt' = 15Jul1999
You can make more useful date comparisons to a date relative to the current date. To do this, use the following:
Today+nnn or Today‑nnn
Where nnn represents a number of days. These filters are especially useful in User Views and automation scripts. For example, the following filter expression returns all entries created within the last seven days:
'Create Dt' > Today‑7
|
Copyright © 2013 CA.
All rights reserved.
|
|