I'm trying to find a way to display time zone for a 'formula' field that ends up being a datetime, in the same way that time zone works for actual datetime fields.
I've reviewed the new SET_TIMEZONE function and some posts here, but not finding an answer.
A simple scenario to help clarify:
- A have a datetime field, my settings are to use the user's time zone when presenting datetimes. So that everyone from around the world understands what time is referred relative to their time. E.g. a meeting start time
- I also have a formula field that calculates a different datetime using the datetime field mentioned above, for example, add x hours to that date time to produce a new date time.
- Now, this is where it all falls apart. The formula field doesn't behave like a regular datetime field, even though, for all intents and purposes outside of its own calculation, I want it to work as though it was a regular datetime field.
- It would appear, that I have no way of this formula datetime appears with the user's time zone, like all my other datetime fields are doing. I can either 1) pick one time zone for the formula field and use the SET_TIMEZONE function to define it. Or 2) present the formula field in GMT and confuse everyone.
Are my assumptions above correct? Or is there some function or capability missing to achieve this?
What I was expecting was for the DATETIME_FORMAT function to support a 'Z' format that indicates the need to present in the user's time zone. But this does not appear to be the case.
All help and comments appreciated, I'm here to learn.