Skip to main content
Topics#EmailPregunta de Iain Reid
Iain Reid ha preguntado en #Email
11 may 2016, 13:41

How do I keep date format from a salesforce report in my email?

I am sending an email via Marketing Cloud using a report created in salesforce. I am using dynamic content for the clients salutation ie %%Title%% %%Last name%% and this pulls through fine. I also am adding a date to show the client when their product matures %%Maturity date%% - in the report the date is dd/mm/yyyy - however in the email send the date shows yyyy-mm-dd.

 

Is there a way to keep the date format as it shows in the report?

 

Thanks,

 

Iain
4 respuestas
  1. Iain Reid
    16 may 2016, 15:17
    Thanks Falk. I was able to update the date format using this in the email content:

     

    %%=DatePart([Maturity date],"Day")=%%/%%=DatePart([Maturity date],"Month")=%%/%%=DatePart([Maturity date],"Year")=%%

     

    where [Maturity date] is the field from my report. 

     

     
Escribir una respuesta...
0/9000