Fun with Dates

[Jeff_Hager]

May have to follow the whole thread below, but I wanted to share something I learned today. If you create a template column with a date/time and any indication of a timezone, then create a math column to convert that template to a date, then it will lock that date/time to that timezone, but show the date/time converted as it would be in the user’s local timezone. It has some weird issues sometimes and doesn’t seem to allow for all types of date math, but it could solve a lot of people’s issues with locking a date/time to a specific timezone.

@Jeff_Hager

Wow, I guess I didn’t realize that this would work for other timezones. So essentially, if you append the timezone code, such as PST, PDT, MST, MDT, CST, CDT, EST, EDT, etc. or if you append +0, +5, +8, etc. (not sure about negatives or decimals), or better yet, GMT+5, GMT+8, GMT-5, GMT-8, GMT+12:30, etc. after any date/time, it will lock that date time to that timezone, and what’s displayed to the user will adjust accordingly to the user’s local time. This could be a huge advantage for creating meetings or appointments that cross timezones as every user would see a time according to their local timezone.