  |
GoFiler Legato Script Reference
Legato v 1.5b Application v 5.24b
|
| Table of Contents | < < Previous | Next >> |
Chapter Five — General Functions (continued)
Overview
The MS1900ToString function converts Microsoft ‘default 1900’ type date to an ISO-8601 formatted date string.
Syntax/Parameters
Syntax
string = MS1900ToString ( int value | string value | float value );
Parameters
value
A date numbered from January 1, 1900 as a string, float or int.
Return Value
Returns a string as an ISO-8601 date and optional time or en empty string on failure. Use GetLastError to retrieve a formatted error code.
Remarks
Certain applications employ a date counting method known as ‘default 1900’ where a date value is stored as days from January 1, 1900. There are a number of variations on this method, this version works with the 1900 basis and compensated for the leap year error in 1900.
Time values can be represented as fractions of days (except for the value as int).
The string value can be a whole number or a real number. The value is converted as appropriate and then run as an integer or as a float.
The returned date string will not have a time attached if the source does not have a fractional of a day.
Related Functions
Platform Support
Go13, Go16, GoFiler Complete, GoFiler Corporate, GoFiler, GoFiler Lite, GoXBRL
Legato IDE, Legato Basic
Page revised 2024-10-21
| Table of Contents | < < Previous | Next >> |
© 2012-2024 Novaworks, LLC. All rights reserved worldwide. Unauthorized use, duplication or transmission prohibited by law. Portions of the software are protected by US Patents 10,095,672, 10,706,221 and 11,210,456. GoFiler™ and Legato™ are trademarks of Novaworks, LLC. EDGAR® is a federally registered trademark of the U.S. Securities and Exchange Commission. Novaworks is not affiliated with or approved by the U.S. Securities and Exchange Commission. All other trademarks are property of their respective owners. Use of the features specified in this language are subject to terms, conditions and limitations of the Software License Agreement.