I have a theoretical question before I spend time testing.
We have locations in 6 time zones. Our I/SR/Task notifications include a Need By date field. Right now they display only in our home office time zone of Central Time (CT).
All I/SRs have a field to record the location code of the Reported For/Reported By user. We also have an Is Visiting checkbox which allows for an override location when a user is not in their home location.
In this example, the notification would go out with a datetime of 7/16/2018 12:00 PM (CT). All locations except the Central time zone have to do the math to determine the Need By time for their location. Not a very global attitude...
Could one create a Global Constant that contains all of the formatting to calculate the datetime based on the provided location code?
$(If IsNull(NeedByDateTime) then "" else If LocationCode in list("SF", "LA") then FormatDate(NeedByDateTime, "MM/dd/yyyy hh:mm tt", "America/Los Angeles") + " PT" else if LocationCode in list("CH", "HU") then FormatDate(NeedByDateTime, "MM/dd/yyyy hh:mm tt", "America/Chicago") + " CT" etc...?
I ask this as I would not want to edit this if statement in every notification should we open an office in a new location and have a new location code.
I think this is a yes, but looking to see if there are caveats to consider?
*We are exploring adding the Timezone field for the NeedBy and Defer/Follow up fields since our data entry is done globally.