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

This is available in the Reporting Matrix.

Show date and time function