You are here: All 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".


Would filter all journal entries with a date greater than April 30,2001.

  • 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.

Related Topics