Differences

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

--- syntax:functions:utctime [2019/05/22 22:37] – created dmitry
+++ syntax:functions:utctime [2021/09/11 00:24] (current) – craigt
@@ Line 1: / Line 1: @@
-===== UtcTime(date_as_number) =====
+====== UTCTime(date) ======
+Category:  Date and Time function
-Converts a local date/time into a UTC date/time.
+\\
+=====Description=====
+This function converts a local date/time into a UTC date/time.
-^  Example  ^  Result  ^ Notes ^
+\\
-| format(utctime(#2019-01-01), 'yyyy-MM-dd HH:mm')  | 2019-01-01 05: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/time to generate the UTC date/time from.|
+**Return value type:** Date serial number
+\\
+=====Remarks=====
+The //date// argument 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=====
+  utctime(#2019-01-01)  //Returns 43466.2083333333 (Equivalent to 2019-01-01 5:00 AM.)
+  format( utctime(#2019-01-01), 'yyyy-MM-dd HH:mm' )  //Returns '2019-01-01 5:00'
+Executed in the Eastern Standard Time zone (UTC-05:00)