$Date: Difference between revisions
No edit summary |
|||
| Line 1: | Line 1: | ||
<p>The $ | <p>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. </p> | ||
<b>Usage</b> | <b>Usage</b> | ||
<p>When using $ | <p>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. </p> | ||
<b>Syntax</b> | <b>Syntax</b> | ||
<p>The format for $ | <p>The format for $Date is:</p> | ||
<p class="code">$ | <p class="code">$Date(year-format,fill-character) | ||
</p> | </p> | ||
<p>See [[Overview of $ | <p>See [[Overview of $Date functions#Overview of $Date functions|Overview of $Date functions]] for syntax details.</p> | ||
<p>If <var class="product">Model 204</var> encounters an error, the function returns all asterisks (*).</p> | <p>If <var class="product">Model 204</var> encounters an error, the function returns all asterisks (*).</p> | ||
<b>Example</b> | <b>Example</b> | ||
<p>The following request prompts a user for data values and automatically stores the current date with each new record (using the 8-character format).</p> | <p>The following request prompts a user for data values and automatically stores the current date with each new record (using the 8-character format).</p> | ||
<p class="code">BEGIN | <p class="code">BEGIN | ||
%DATE = $ | %DATE = $date | ||
GET.FIRST: %A = $READ('ENTER FIELD A') | GET.FIRST: %A = $READ('ENTER FIELD A') | ||
%B = $READ 'ENTER FIELD B') | %B = $READ 'ENTER FIELD B') | ||
Revision as of 15:32, 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