- Jun
- 744
- 16
There is an inconsistency in the date format specifications between the
functions @DATE and @MAKEDATE. For @DATE, format 4 is defined as:
4 ISO (yyyy/mm/dd)
For @MAKEDATE it is:
4 ISO 8601 (yyyy-mm-dd)
In one case the separator is slashes; in the other it is hyphens. The
@MAKEDATE function does generate output with hyphens. The @DATE function
seems to accept either hyphens or slashes in the input.
If nothing else, the help files should be corrected.
-- Jay
functions @DATE and @MAKEDATE. For @DATE, format 4 is defined as:
4 ISO (yyyy/mm/dd)
For @MAKEDATE it is:
4 ISO 8601 (yyyy-mm-dd)
In one case the separator is slashes; in the other it is hyphens. The
@MAKEDATE function does generate output with hyphens. The @DATE function
seems to accept either hyphens or slashes in the input.
If nothing else, the help files should be corrected.
-- Jay