You are here: Help Topics > Accounting and Assurance > Calculations, Functions and Linkages > Date Fields
-- Reference --
Date Fields
All database date fields containing dates are stored in the format "yyyymmdd".
Example 1:
GL->DATE>"04/30/2001"
Would filter all journal entries with a date greater than April 30,2001.
Notes
-
The date format can be used but must be in the format dd/mm/yy and must be enclosed by quotes "’’.
- For Julian calendar, the date format is the number of days between March 1, 1990 and the particular date. For example, December 31, 2003 has a Julian serial number of 37925.