In our Marketing Cloud emails we send emails which contain time slots for Appointments to customers.
The data is stored in UTC time in Sales Cloud, and then copied over to Marketing Cloud Data Extensions in the same timezone (using MC connector). However the customers are based in the UK so they can be GMT or BST (+ 1 hour), how can we display the correct time without having to manually add/remove offsets every 6 months when the timezeone changes?
This is my current AMPScript
set @AppointmentDate = "4/14/2019 7:15:00 AM" set @AppointmentDate = SystemDateToLocalDate(@AppointmentDate) set @formatDate = FormatDate(@AppointmentDate, "YY/MM/DD","", "en-GB") set @formatTime = Format(@AppointmentDate, "h:mmtt") Outputline(Concat(@formatDate, " ", @formatTime))
The MC Account is set to
GMT*, the * indicates DST is being observed so its (+1 hour)