Sep 30, 2024 07:09 AM
I have a date field that contains "2020-11-26" and another field of type selection. I would like to put the date "2020-11-26" in the selection field by transforming it into "26/11/2024". How can I do this?
Sep 30, 2024 07:33 AM
What do you mean? If you want to copy whole date field into the selection field, duplicate date field, change format in duplicated field from ISO to European, then copy-paste it to Selection field.
If you want to do it by automation, instead of duplicate, create formula field with only date field name in formula text. It will reflects the same date as date field. In settings, Formatting, choose desired format and use its output in Automation.
Oct 02, 2024 08:26 PM
Try using the datetime_format function. This will let you change the order of the values in a date field.