Julian date formats include the following: yyddd, yyyyddd, yy.ddd, yyyy.ddd, yy/ddd, or yyyy/ddd. The format is:
Day of a year from 001 to 366.
Calendar year from 00 to 99 this year is stored as 1900 to 1999.
Calendar year from 1900 to 2155.
Julian dates 98000, 99000, 99365, 99366 and 99999 are also accepted in any of the previous formats. For example, you can enter the date July 19, 1997 as:
|
97200 |
1997200 |
|
97.200 |
1997.200 |
|
97/200 |
1997/200 |
|
19Jul97 |
19Jul1997 |
|
07/19/97 |
07/19/1997 |
Also, as a DSCL Select or Exclude criteria, you can specify the date in the form TODAY, TODAY-n or TODAY+n, where n is a number of days in the past or future. For example:
SELECT CRITERIA=(CREDT,EQ,TODAY)
SELECT CRITERIA=(MODDT,GE,TODAY-5)
SELECT CRITERIA=(USEDT,LT,TODAY-30)
SELECT CRITERIA=(EXPDT,LT,TODAY+7)
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|