A way to show the UTC timezone conversion in the timestamp?

joebenz

I have the PST timezone conversion set for my company's instance of Domo, meaning that all timezones fed in from our database are being converted from UTC to PST.

Example: if there is timestamp in my database saying 2024-03-15T11:43:02, then it will show (post-conversion to PST) as Mar 15, 2024 3:43:02PM as the timestamp in Domo. Is there a way to have the converted timestamp but also show the conversion to UTC?

Here is how I would want it to look 2024-03-15T3:43:02-8:00

ArborRose

To display a timestamp in Domo with both the converted time zone (PST) and the corresponding UTC offset, use Beast Mode to manipulate the timestamp field by adding or subtracting hours (based on your location). You can calculate the UTC offset for PST (UTC-8:00) and append it to the timestamp using CONCAT.

ArborRose

To display a timestamp in Domo with both the converted time zone (PST) and the corresponding UTC offset, use Beast Mode to manipulate the timestamp field by adding or subtracting hours (based on your location). You can calculate the UTC offset for PST (UTC-8:00) and append it to the timestamp using CONCAT.

joebenz

Thanks @ArborRose