Email Template : Convert DateTime to Date

Question

Hi
I am looking to covert the value returned by {::Ha_Hardship::date_entered::} in an email to just the Date
e.g. in the resulting Email, I get '23/01/2024 15.44'
I want to just get '23/01/2024'
Any ideas :-)
Cheers and thanks in advance
Warde

Warde Wynter · Accepted Answer

Hi Warde Wynter , 
 Email templates don't support changing the data format of field variables. To achieve this outcome, you would need to create a custom date field in the module and use a formula to extract the date value from the date_entered field. The following formula would work for your custom field: 
 date(
 toString(
 $date_entered
 )
) 
 Once you create the field, you would need to trigger a ' Recalculate Values ' from the list view to populate the new field before you can use it in an email template. 
 Chris