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
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
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
