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.