How to change the date format for the receipt date in a template

Question

I'm using the "Thank-you letters - print or email" functionality to generate a receipt for contributions. I created a new template with all the information needed. However we have a problem to display the receipt date at the correct format. Actually, when I chose the token "Receipt date" in the combobox, Civi inserts {contribution.receipt_date} in my template, and when I generate a PDF, it displays the date with the hours : for example, "2019-02-25 16:01:00". We would just like to display the date (without the hours) at this format : dd/mm/YYYY (for example : "25/02/2019"). I tried to add code like "date_format" in the source of the template to change the date format, but it didn't work. Is there an easy way to change it ?

Thanks !

Answer 1

If you want 28 February 2019 {foreach from=$contributions item=contribution} {assign var="date" value=$contribution.receive_date|date_format:"%d %B %Y"}

If you want 28 02 2019 {foreach from=$contributions item=contribution} {assign var="date" value=$contribution.receive_date|date_format:"%d %m %Y"}

If you want it to look better (28/02/2019) you can add slashes value=$contribution.receive_date|date_format:"%d/%m/%Y"}

Answer 2

As of CiviCRM 5.43, there is a much simpler answer:

{contribution.receipt_date|crmDate:"shortdate"}

There is full documentation for the crmDate filter.

Answer 3

You will need to have Smarty template processing turned on for mailings: make sure CIVICRM_MAIL_SMARTY is defined in your civicrm.settings.php file, as described in the CiviCRM User Guide.

Then, replace the {contribution.receive_date} token in your message with Smarty code such as this:

• For a date like "26/01/2020" (dd/mm/yyyy):

  {capture assign=formattableDateReceived}{contribution.receive_date}{/capture}{capture assign=formatString}%d/%m/%Y{/capture}{$formattableDateReceived|date_format:$formatString}

• For a date like "December 7, 2020":

  {capture assign=formattableDateReceived}{contribution.receive_date}{/capture}{capture assign=formatString}%B %e, %Y{/capture}{$formattableDateReceived|date_format:$formatString|strip}

• For a date like "01/26/2020" (mm/dd/yyyy):

  {capture assign=formattableDateReceived}{contribution.receive_date}{/capture}{capture assign=formatString}%m/%d/%Y{/capture}{$formattableDateReceived|date_format:$formatString}

• For a date like "1/26/2020" (m/d/yyyy):

  {capture assign=formattableDateReceived}{contribution.receive_date}{/capture}{capture assign=formatString}%m/%d/%Y{/capture}{capture assign=mdyCleanupFind}#(^|/)0#{/capture}{capture assign=mdyCleanupReplace}$1{/capture}{$formattableDateReceived|date_format:$formatString|regex_replace:$mdyCleanupFind:$mdyCleanupReplace}

These four examples use Smarty's date_format, strip and regex_replace modifiers. Due to the way that Civi applies Smarty to thank-you letters (as of Civi 5.32), we have to capture the parameters for each of these modifiers in a variable before using them.

The patterns above should work for other date fields as well (receipt_date, cancel_date etc.)

Answer 4

This code helped me to include an European date format into PDF-invoices:

{$invoice_date|date_format:"%d.%m.%Y"}

in your case you have to change invoice_date with the desired contribution.receipt_date