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?
+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
- 275 replies
Try using the datetime_format function. This will let you change the order of the values in a date field.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.