Skip to main content
Topics#EmailIain Reid の質問
Iain Reid が「#Email」で質問
2016年5月11日 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 件の回答
  1. Iain Reid
    2016年5月16日 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. 

     

     
回答を記入...
0/9000