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
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
Hi Chris...many thanks for prompt reply and advice
'much appreciated
Cheers
Warde