$DateJ: Difference between revisions
Jump to navigation
Jump to search
m (link repair) |
m (misc formatting) |
||
| Line 2: | Line 2: | ||
The <var>$DateJ</var> function returns the current Julian date as a 5- to 7-character string in one of these formats: </p> | The <var>$DateJ</var> function returns the current Julian date as a 5- to 7-character string in one of these formats: </p> | ||
<ul> | <ul> | ||
<li | <li>YY-DDD, format, for example, <code>97-342</code></li> | ||
<li | <li>CYY-DDD format, for example, <code>097-342</code></li> | ||
<li | <li>YYYY-DDD format, for example, <code>1997-342</code></li> | ||
</ul> | </ul> | ||
<p> | <p> | ||
| Line 13: | Line 13: | ||
==Usage== | ==Usage== | ||
<p> | <p> | ||
When using <var>$DateJ</var> in field values, make sure that all values of <var>$DateJ</var> are in the same format. You get incorrect results when sorting records if you mix | When using <var>$DateJ</var> in field values, make sure that all values of <var>$DateJ</var> are in the same format. You get incorrect results when sorting records if you mix YYYY, CYY, and YY formats. </p> | ||
==Syntax== | ==Syntax== | ||
Revision as of 22:38, 25 September 2015
The $DateJ function returns the current Julian date as a 5- to 7-character string in one of these formats:
- YY-DDD, format, for example,
97-342 - CYY-DDD format, for example,
097-342 - YYYY-DDD format, for example,
1997-342
The default is five 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 (*).