Dennis of Marketing Cloud Team
1/17/2019 - 1:54 PM

AMP - Translate Salesforce Date field

When a Salesforce date field is retrieved from the Synchronized Data Extension, the American date and time zone is used.

With SystemDateToLocalDate you can easily translate it to time zone of the MC MID settings.

Meer opties mbt date format:

https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-programmatic-content.meta/mc-programmatic-content/dateTimeFormatting.htm

With Format Date you can translate it to the dutch date format.

SF Synch DE date fields
content_copyfile_download
/* System date to local date only */
SystemDateToLocalDate(StartDate__c), '', 'HH:MM', 'nl-NL')

/* Format Date only */
FormatDate(StartDate__c, '', 'HH:MM', 'nl-NL')

/* Combined */
FormatDate(SystemDateToLocalDate(StartDate__c), '', 'HH:MM', 'nl-NL')