Differences

This shows you the differences between two versions of the page.

--- syntax:functions:localtime [2019/11/16 14:46] – dmitry
+++ syntax:functions:localtime [2021/08/30 02:30] – craigt
@@ Line 1: / Line 1: @@
-===== LocalTime(date_as_number) =====
+====== LocalTime(date) ======
+Category:  Date and Time function
-Converts a UTC date/time into a local date/time.
+\\
+=====Description=====
+This function converts a UTC date-time into a local date-time.
-^  Example  ^  Result  ^ Notes ^
+\\
-| format(localtime(#2019-01-01), 'yyyy-MM-dd HH:mm')  | 2018-12-31 19:00 | Executed in Eastern Standard Time zone (UTC-05:00)|
+=====Arguments=====
+^Argument^Type^Description^
+|date|Date or Number (date serial)|An expression representing a date.  The UTC date-time value to convert to a local date-time value.|
+**Return value type:** Number (date-time serial)
+\\
+=====Remarks=====
+The //date// arguments can take any value or expression that evaluates to a date serial value.  Examples include:
+  * A date string:  #2019-12-12
+  * A date serial value: 43811 (the date serial for "2019-12-12")
+  * A date value created using any of the Date/Time functions that returns a date serial value.
+\\
+=====Examples=====
+  format( localtime(#2019-01-01), 'yyyy-MM-dd' )  //Returns '2018-12-31' (Executed in the EST zone (UTC-05:00))
+\\
+=====See also=====
+  * [[syntax:functions:weekend|Format(date,format)]]
-===See also===
-* [[syntax:functions:format|Format(date_as_number, format)]]