UTC Time and Date Functions

Often when working across time zones it is necessary to pass dates and times using UTC format. Infiniti has the following funcitons

Usage

UtcToday() The current date (no time) in UTC time.
UtcNow() The current date and time in UTC time
UtcToLocal(d) Converts a UTC time zone date into the users local time zone. Useful for displaying to users, or in documents.
LocalToUtc(d) Converts a local time zone date to UTC.

Parameters

d - Date value. If this value is hard-coded it must be prefixed with a hash (#) character, e.g. #25/12/2020

Examples

Present a UTC time as local time in a specified Format.
 
format(UtcToLocal([q1.SubmissionDateTime]),"dd-MMM-yyyy hh:mm")

Related Articles

date time zone date diff timezone UTC
 

Keywords

dateformat