Remove time stamp from a Salesforce Field in Marketing Cloud

Question

I do want to remove the time from a Salesforce field retrieved from the object CampaignMember.

I had tried this the following amspcript code in my email but I do still have errors to send it :

%%[
VAR @MemberId, @IdCamp, @SubscriberKey, @datecreationdevis,
SET @codecampagne = 'TRI'
SET @CampaignmemberId = AttributeValue("CampaignMember:Id")
SET @IdCamp = AttributeValue("CampaignMember:Campaign:Id")
SET @SubscriberKey = AttributeValue("CampaignMember:Contact:Id")
SET @datecreationdevis = FormatDate(CampaignMember:OpportunityCreationDate__c, "DD/MM/YYYY", "fr-FR")
]%% 

Bonjour %%CampaignMember:FirstName%% %%CampaignMember:LastName%%, 

Suite au devis présenté le %%@datecreationdevis%%, j'aimerais vous proposer un RDV prochainement

Answer 1

Try this:

%%[
VAR @MemberId, @IdCamp, @SubscriberKey, @datecreationdevis,
SET @codecampagne = 'TRI'
SET @CampaignmemberId = AttributeValue("CampaignMember:Id")
SET @IdCamp = AttributeValue("CampaignMember:Campaign:Id")
SET @SubscriberKey = AttributeValue("CampaignMember:Contact:Id")
SET @OpportunityCreationDate = AttributeValue("CampaignMember:OpportunityCreationDate__c")
SET @datecreationdevis = FormatDate(@OpportunityCreationDate, "DD/MM/YYYY", "fr-FR")
]%% 

Bonjour %%CampaignMember:FirstName%% %%CampaignMember:LastName%%, 

Suite au devis présenté le %%=v(@datecreationdevis)=%%, j'aimerais vous proposer un RDV prochainement

Inside the FormatDate function, you just put the Data Extension field name, without declaring it as a variable first or without using the quotation marks, which would tie it to your Sendable DE, that's why it didn't know where to pull the date from. This should now work.