StringToDateTime: Difference between revisions

Line 3:

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~~

==== Usage ====

<syntaxhighlight>StringToDateTime("MM/dd/yy hh:mm:ss tt")</syntaxhighlight>

or:

<syntaxhighlight>StringToDateTime("MM/dd/yyyy hh:mm:ss tt")</syntaxhighlight>

Where: [[MM]] - month*

[[dd]] - day of the month*

[[yy]] - a two-digit year

[[yyyy]] - a four-digit year

[[hh]] - hours

[[mm]] - minutes

[[ss]] - seconds

[[tt]] - AM/PM designator

==== 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.

@@ Line 3: / Line 3: @@
 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
+==== Usage ====
+<syntaxhighlight>StringToDateTime("MM/dd/yy hh:mm:ss tt")</syntaxhighlight>
+or:
+<syntaxhighlight>StringToDateTime("MM/dd/yyyy hh:mm:ss tt")</syntaxhighlight>
+Where: [[MM]] - month*
+[[dd]] - day of the month*
+[[yy]] - a two-digit year
+[[yyyy]] - a four-digit year
+[[hh]] - hours
+[[mm]] - minutes
+[[ss]] - seconds
+[[tt]] - AM/PM designator
 ==== 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.