Display Modified Date/Time in 1 Consistent Time Zone

cantpickname

Is there a way to pull the UTC or server-stored Modified Date and NOT show my time zone's display?

My ultimate goal: we need to display the last modified date AND time consistently regardless of the user's time zone.

Paul Newcome

HERE is a link to a thread regarding time based solutions. There is a link in the main post that provides a solution for converting time zones.

cantpickname

That is wonderful, Paul. Thank you!

That achieves the entire second part of what I needed to do. But I still need to have my base Date/Time stamp the UTC of the system column, so that my calculations work regardless of which time zone someone has in their personal settings. Is there any way to get the full Date and Time stamp in UTC from "Modified" or "Created" fields, let's say if my personal settings are EST.

Paul Newcome

HERE is a link to a thread regarding time based solutions. There is a link in the main post that provides a solution for converting time zones.

cantpickname

That is wonderful, Paul. Thank you!

That achieves the entire second part of what I needed to do. But I still need to have my base Date/Time stamp the UTC of the system column, so that my calculations work regardless of which time zone someone has in their personal settings. Is there any way to get the full Date and Time stamp in UTC from "Modified" or "Created" fields, let's say if my personal settings are EST.

Paul Newcome

If you are tracking WHO created/changed the row, you could build a table out (even in a separate sheet) that lists each user, their timezone, and the difference to UTC.

Then in place of a static number in the formula where you add/subtract hours you would reference this table.

The table would need to be manually created and managed, but once built should provide what you need.

NateDwg

Sorry Paul, regardless of WHO creates it, or where they are from, or if they are a guest, all our time / date stamps MUST be displayed per regulations in UTC format, so again regardless of personal set time zone, the output displayed should always be able to be shown in UTC. Is there a way to do this so the output from the Created On/Modified On field is always shown in ISO 8601 format, in Zulu/UTC time?

Paul Newcome

@NateDwg You should be able to leverage the API, the premium add-on Bridge, or some other similar third party app if you are not able to create a database of all users and their time zones.