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?
Prblem automatisation
+4
+25What 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.
+17- Employee
Try using the datetime_format function. This will let you change the order of the values in a date field.
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.