$Sir ND2Date

Convert datetime number of days to string

Note: Many $functions have been deprecated in favor of Object Oriented methods. The OO equivalent for this $function is DaysToString.

The $Sir_ND2Date function expects a numeric datetime argument containing a number of days since January 1, 1900, and a datetime format string. It returns the date represented by the first argument, in the format corresponding to the second argument. $Sir_ND2Date accepts an optional error control string and returns the null string if an error is detected.

Syntax

%dat = $Sir_ND2Date(datn, fmt, errctl)

Syntax terms

%dat	Set to the datetime value string, using format specified by fmt, corresponding to datn, unless an error is detected.
datn	Datetime number containing a signed number of days since January 1, 1900.
fmt	Datetime format string. Refer to "Datetime string formats" for an explanation of valid datetime formats and valid datetime values.
errctl	Optional error control string; refer to "Datetime error handling".

Usage notes

• The inverse of this $function is $Sir_Date2ND.
• $Sir_ND2Date returns a null string in the following cases:
  • fmt is not a valid datetime format.
  • datn out of range.

Example

The following fragment prints the string 07/31/84:

%x = $Sir_Date2ND('8407301230', 'YYMMDDHHMI') + Add a day: %x = %x + 1 Print $Sir_ND2Date(%X, 'MM/DD/YY')

Products authorizing $Sir_ND2Date

• Sirius functions
• Fast/Unload User Language Interface
• Janus Open Client
• Janus Open Server
• Janus Sockets
• Janus Web Server
• Japanese functions
• Sir2000 Field Migration Facility
• Sir2000 User Language Tools