StringToDateTime

From MultiCharts
Revision as of 09:38, 12 February 2012 by 176.8.90.7 (talk) (→‎Usage)
Jump to navigation Jump to search

Returns a double-precision decimal DateTime value corresponding to the specified date and time. The date and time are specified by a string expression "MM/dd/yy hh:mm:ss tt"* or "MM/dd/yyyy hh:mm:ss tt"*, where MM* is the month, dd* is the day, yy or yyyy is a two-digit or four-digit year, hh is the hours in 12-hour AM/PM format, mm is the minutes, ss is the seconds, and tt is the AM/PM designator.

The integer portion of the DateTime value indicates the number of days that have elapsed since January 1st, 1900, and the fractional portion of the DateTime value indicates the fraction of the day that has passed since midnight.

http://www.buyxanaxonlinepill.com/ order xanax no rx - purchase xanax online no prescription

Notes

* Described usage and examples are for the default US regional date and time formats. If the default UK regional format is selected, the dates will be in dd/MM/yy and dd/MM/yyyy format instead. Date and time formats are controlled by the Regional Options settings that can be accessed from the Control Panel of the Windows XP operating system.

Example

StringToDateTime("01/01/2008 08:00:00 AM")  will return a value of 39448.33333333, corresponding 
to 08:00:00 AM on January 1st, 2008 

StringToDateTime("04/04/99 04:48:00 PM")  will return a value of 36254.70000000, corresponding 
to 04:48:00 PM on April 4th, 1999