$Date: Difference between revisions
(Automatically generated page update) |
|
(No difference)
|
Revision as of 15:30, 15 July 2014
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