$DateJ

From m204wiki
Revision as of 13:18, 20 April 2013 by Alex (talk | contribs) (Automatically generated page update)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

The $DATEJ function returns the current Julian date as a 5- to 7-character string in yy-ddd, format, for example, 97-342; or cyy-ddd format, for example, 097-342; or yyyy-ddd format, for example, 1997-342. The default is 5 characters. If $DATEJ is stored as a field value, you can use this form to sort records chronologically.

Usage

When using $DATEJ in field values, make sure that all values of $DATEJ are in the same format. You get incorrect results when sorting records if you mix yyyy, cyy, and yy formats.

Syntax

The format for $DATEJ is:

$DATEJ(year-format,fill-character)

For further syntax details see Overview of $DATE functions.

If Model 204 encounters an error, the function returns all asterisks (*).