I am sending out emails from the Marketing cloud. The email template uses AMPScript from a Date time field in Salesforce. I only need to capture the Date part of the field, however, since the clocks have been moved forward this no longer works. Is this working as designed or is there a better way to manage the time stamp.
Var @CBDateTime, @CBDateString, @CBTimeString Set @CBDateTime = [Field in Salesforce] Set @CBDateTime = SystemDateToLocalDate(@CBDateTime) Set @CBDateString = Formatdate(@CBDateTime, "d MMMM yyyy","","en-GB") Set @CBkTimeString = Formatdate(@CBDateTime, "hh:00 tt","","en-GB")
This then displays as 08:00 AM and not 09:00 AM as per the field in Salesforce which contains 09/04/2018 09:00