nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Hannah Humbert - Simpla Workflows

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

All comments

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

Hannah Humbert - Simpla Workflows

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