Closed
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?
Posted: 5 years ago
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.