i have a question regarding the format of DateTime variable pulled into an Marketing Cloud Content Builder Email from Sales Cloud using AMPscript. Note I am splitting out the date from the time.
I am able to change the format to the Locale that i need (DE) but when populating, it is pulling in some extra characters directly after the date and time, e.g "ae" or "aAe" and time section is not working
In Sales Cloud and Synchronized DE stored as:
Wednesday, January 10, 2018 9:19 AM
Without any formatting it populates like this:
I need it in German locale and date and time separated.
Current ampscript in content block:
%%=FormatDate(@date, "dd. MMMM. yyyy ", "date", "de-DE")=%%
%%=FormatDate(@date, "HH:mm ", "date", "de-DE")=%%
10. Januar. 2018 10ae
09:01 AM 10aAe
Alternatively, I would prefer to set the format or formatdate in the Variable declaration in the header, but again not sure what is best.