$Date

From m204wiki
Revision as of 15:30, 15 July 2014 by Mlarocca (talk | contribs) (Mlarocca moved page $DATE to $Date: Lower case change)
Jump to navigation Jump to search

The $DATE function returns an 8- or 10-character string equal to the current date in yy-mm-dd format (for example, 90-09-20) or yyyy-mm-dd format (for example, 1990-09-20). The default is 8 characters. If $DATE is stored as a field value, you can use this form to sort records chronologically.

Usage

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

Syntax

The format for $DATE is:

$DATE(year-format,fill-character)

See Overview of $DATE functions for syntax details.

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

Example

The following request prompts a user for data values and automatically stores the current date with each new record (using the 8-character format).

BEGIN %DATE = $DATE GET.FIRST: %A = $READ('ENTER FIELD A') %B = $READ 'ENTER FIELD B') STORE RECORD FLD A = %A FLD B = %B . . . DATE STORED = %DATE END STORE IF $READ('NEXT RECORD: Y OR CR') EQ - 'Y' THEN JUMP TO GET.FIRST END IF END