DateToString: Difference between revisions
From MultiCharts
m
→Notes
No edit summary |
m (→Notes) |
||
(3 intermediate revisions by 3 users not shown) | |||
Line 3: | Line 3: | ||
The integer portion of the DateTime value specifies the number of days since January 1st, 1900, and the fractional portion of the DateTime value specifies the fraction of the day since midnight. | The integer portion of the DateTime value specifies the number of days since January 1st, 1900, and the fractional portion of the DateTime value specifies the fraction of the day since midnight. | ||
== Usage == | |||
<syntaxhighlight>DateToString(DateTime)</syntaxhighlight> | <syntaxhighlight>DateToString(DateTime)</syntaxhighlight> | ||
Where: | Where: | ||
:'''DateTime''' - a double-precision decimal DateTime value to be converted to a string expression representing the date. | |||
== Notes == | |||
The output | * The output in the examples below is in the default regional date format of the user. Date format is controlled by the Regional Options settings that can be accessed from the Control Panel of the Windows operating system. Depending on your regional settings your output might differ from the examples below. | ||
* Use [[FormatDate]] to have more control over the formatting of the outputted string. | |||
== Examples == | |||
<syntaxhighlight>DateToString(39448.25000000)</syntaxhighlight> | |||
Will return the string "1/1/2008". | |||
<syntaxhighlight>DateToString(ComputerDateTime)</syntaxhighlight> | |||
Will return the string "19-2-2012" for someone with European Regional settings. | |||
[[Category:Date and Time Routines]] | [[Category:Date and Time Routines]] |