How do I display a UTC date/time using my local date/time?

 To display UTC date/time values in the local date/time settings, use the SHIFTDATETIME function:

For example:

SHIFTDATETIME({datetimefield}, "UTC,0", "")

This function can also be used to change the timezone of any date/time field, it accepts 3 parameters:

1. The datetime field itself

2. The timezone and offset that the datetime field is stored in. (This must be enclosed in double quotes.)

3. The timezone and offset to swicth the datetime field to, leave this as an empty string if you wish to use the local datetime settings of the workstation you are running the report on. (This must be enclosed in double quotes.)


Please sign in to leave a comment.