Previous Topic: Gregorian Date FormatsNext Topic: Year 2000 Considerations


Julian Date Formats

Julian date formats include the following: yyddd, yyyyddd, yy.ddd, yyyy.ddd, yy/ddd, or yyyy/ddd. The format is:

ddd

Day of a year from 001 to 366.

yy

Calendar year from 00 to 99 this year is stored as 1900 to 1999.

yyyy

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: