Concatenate Date & Time Properties to DateTime property with dynamic Time Zone
We have a requirement to concatenate 2 properties and display in a grid.
1. Date Type Property (Ex: 20190101)
2. Time of the Day type property (Ex: 043000)
Above properties needs to concatenate and display in DateTime format.
Issue - When formatting the concatenated values it does not allow to enter Time Zone as 'ET' which we receive from the external system.
Question - Is there a OOTB function to convert 'ET' time zone to 'EDT' or 'EST' by considering the day light savings?
Pegasystems Inc.
US
There is no OOTB function to do this. The issue is that the dates for Standard and Daylight Savings Times change every year. A simple SQL function cannot accommodate the date changes.
You would need either a service that would tell you if it is EST or EDT, or a manually maintained table in the database with the dates.