Remove time stamp from personalization strings

Question

I looking for a way to remove the time stamp of a date field when using personalization strings. I got this format when using PS: 3/1/2020 12:00:00 AM. I want to remove that part "12:00:00 AM". Here is my personalization strings for the date field: %%=lookup('CONTRATS_HABITATION','DATE_EFFET_CONTRAT','CONTACT_ACCOUNT_ID',CONTACT_ACCOUNT_ID)=%%

I have read in another post that I could use that function FormatDate(Now(), "MMM dd, yyyy") by replacing the Now() by my date field. But I don't know how to proceed. Does anyone have some insights about this?

Thanks!

UPDATE I just wanted to add a solution to my last comment. Since the field is contained in a non-sendable data extension, I had to find a way to retrieve it and to truncate the date field. Here is my solution: %%=v(FormatDate(lookup('CONTRATS_HABITATION','DATE_EFFET_CONTRAT','CONTACT_ACCOUNT_ID',CONTACT_ACCOUNT_ID), "dd MMMM yyyy",,"fr-CA"))=%%

Answer 1

That's right, you can use the FormatDate function to truncate the time part from your datetime.

In your case, it would be something like:

Set @DATE_EFFET_CONTRAT_TRUNC = FormatDate(DATE_EFFET_CONTRAT, "MMM dd, yyyy")

The output would be:

Mar 01, 2020

In this case, I assume your personalization string is DATE_EFFET_CONTRAT

Also, I see that you are using french language. So just in case you need to format your date using the french format, you can try something like:

Set @DATE_EFFET_CONTRAT_TRUNC = FormatDate(DATE_EFFET_CONTRAT, "dd MMMM yyyy",,"fr-CA")

The output would be:

01 mars 2020

If you want to use only this date in your subject line, you can try:

%%=v(FormatDate(DATE_EFFET_CONTRAT, "dd MMMM yyyy",,"fr-CA"))=%%

Otherwise, you need to use create a @subjectLine variable, and concatenate all your content to it on the email content and put in your subjectline textfield: %%=v(@subjectLine)=%%

Reference:

Checkout this FormatDate page for more options..