Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Prblem automatisation

Topic Labels: Automations Data Formulas Sync
164 2
cancel
Showing results for 
Search instead for 
Did you mean: 
farah
5 - Automation Enthusiast
5 - Automation Enthusiast

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?

2 Replies 2

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.

Dan_Montoya
Community Manager
Community Manager

Try using the datetime_format function.  This will let you change the order of the values in a date field.