SHOWDATETIME
The SHOWDATETIME function returns the date and time period based on a given set of arguments.
Syntax
SHOWDATETIME(timeZone, format)
Arguments
timeZone- Select the UTC time zone. Required.
format- Define the date format to display the date and time. Optional.
Return value
Date and time in UTC.
Example
SHOWDATETIME(TIMEZONE.[(UTC+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna])
//Returns the date and time for the specified UTC timezone
SHOWDATETIME(TIMEZONE.[(UTC+00:00) Dublin, Edinburgh, Lisbon, London], 'DD-MMMM-YYYY hh:mm:ss A')
//Returns the date and time for the selected UTC timezone in the specified format

Last updated
Was this helpful?