Date only custom field

[Alisha]

Good afternoon,

Please could we have some date only custom fields. I have used h_custom_21 for the Date Control in a capture, but when I use h_custom_21 in an email template, it inputs the time as well as the date. We would only like the date to show please.

I have tried to use Cloud Automation Utilities to convert h_custom_21 to Date only (which seems like a complicated way to just display the Date), and put the result on the Timeline to check it and it does display the date only. I then update result in the custom field, but when using h_custom_21 in the email template, it still shows the time.

A date only custom field would be really helpful here.

Many thanks,
Alisha

[Steve Giller]

I'm not aware of any plans to change/add to the current Custom Fields, but if you convert the DateTime to Date in the format of your choice, then store it in a Text field this will prevent the Email Template from trying to format it.

[Alisha]

Hi @Steve Giller,

I stored the date in h_custom_e but in the Email Template, it outputs the date as 2023-06-07 (for today's date). Is there anyway to change the output to something less confusing, e.g. 7 June 2023, as it's not always clear if the date format is 7 June or 6 July, depending on which country you're from!

Many thanks,
Alisha

[Steve Giller]

Just to appease my pedantic side, 07-06-2023 can be confusing (mainly to Americans) but 2023-06-07 is always June 7th.

However, the Hornbill iBridge Utilities operation has a Date Formatter function that may be of use.