Reference a date set in a custom field

[OLEILÕES]

I am making an automation to post a comment, referencing a date which is set by a custom field. Ia m using {{%CUSTOM FIELD}}.

The comment is posted with the date, however always in the format MONTH DD, YYYY - hh:mm, and always in ENGLISH

Is there any way to change the format?

I need it to be in Portuguese, or at least in the format DD/MM/YYYY - hh:mm

[Hannah Humbert - Simpla Workflows · Accepted solution]

Let's say you have a custom date field called "Delivery Date". The below should work:

when custom field "Custom date" is set, post comment "Custom date has been set to {{%Delivery Date}~DD/MM/YYYY - hh:mm}"

You need to make sure the custom field is spelled exactly the same (it is case-sensitive). 

[OLEILÕES]

Hello Hannah, trying it in this format, I got the output comment:

"Custom date has been set to invalid date"

The custom field is {{%Data 1º Leilão}}, I made sure to spell exactly on the automation. Maybe the bug comes from an unknown character in the code (ã)?

I will do more tests

[OLEILÕES]

Hannah, I believe I was right, when I changed the custom field name simply to {{%Data 1}}, I got no more invalid date output.

Thank you

[OLEILÕES]

I found this support page: https://support.atlassian.com/trello/docs/arithmetic-and-formatting-in-date-variables/

I tried the input:

{{%CUSTOM FIELD}~DD.MM.YYYY - hh:mm}

And got the output: invalid date