Hi Everyone !
I have trouble using the concatenate formula with datefield. My concatenate is supposed to be “Training name - Beginning date - Ending date”
My dates format are displayed as european and doesn’t include time. When I use the concatenate, it shows this : “activité ludique & éveil sensoriel - 2019-01-19T00:00:00.000Z” - The last part shouldn’t appear, and the date format is wrong. I read Airtable guide on DATETIME_FORMAT configuration, however it just doesn’t work because of an “Invalid formula”, and I don’t know if it’s because of the way i’m writing it…
I’ve tried like this :
- CONCATENATE({Formation} & " - " & DATETIME_FORMAT(Date, ‘DD-MM’){Date de début})
- CONCATENATE({Formation} & " - " & DATETIME_FORMAT({Date de début}, ‘DD-MM’)
… And various combination of {} & () :grinning_face_with_smiling_eyes:
Problem 1 : make the concatenate work without time :grinning_face_with_big_eyes:
Problem 2 : I’ve displayed time in european format but in my concatenate it doesn’t display the same way
Ps1 : “Date de début” correspond to “beginning date” field (it is configured as a date field)
Ps2 : I only included “Date de début” to exemplify my problem, however i’d wish my concatenate to include the beginning date and the ending date (which are in two separated field)
Hope this was clear enough, thank you all for your time and your help