Hey team - wondering what the best method is to cast times in pipeline builder from a static timezone (UTC) to local timezones based on another column?
Was thinking to use the convert from UTC board - Does that handle daylight savings?
You’ve got the right board, it will convert the time based on the provided time zone. This is daylight savings aware - so you’ll want to make sure you get the right timezone as different locations may observe daylight savings time differently.
If you do not want daylight savings to be taken into account, you can use the Timestamp Add board with a time zone offset.
1 Like