Difference between revisions of "DateToString"
Jump to navigation
Jump to search
(Created page with "Returns a string expression corresponding to the date (integer) portion of the specified DateTime value. The integer portion of the DateTime value specifies the number of da...") |
|||
| Line 12: | Line 12: | ||
==== Example ==== | ==== Example ==== | ||
| − | + | <syntaxhighlight>DateToString(39448.25000000) will return the string "1/1/2008".</syntaxhighlight> | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
[[Category:Date and Time Routines]] | [[Category:Date and Time Routines]] | ||
Revision as of 11:11, 19 January 2012
Returns a string expression corresponding to the date (integer) portion of the specified DateTime value.
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
DateToString(DateTime)
Where: DateTime - a double-precision decimal DateTime value to be converted to a string expression representing the date
Notes
The output example is in the default US regional date format. Date format is controlled by the Regional Options settings that can be accessed from the Control Panel of the Windows XP operating system.
Example
DateToString(39448.25000000) will return the string "1/1/2008".
