Create date out of numbered fields

[Andreas_Tystad]

Hello! I am organizing and archiving all the films shown from our local cinema. We started in Google Sheets andhave now imported into Airtable. Now we have seperate fields for the Year the film was shown, the month and the day. Is there a formula that combines the numbered fields to a date field? I can’t seem to find it anywhere.
Can anyone help? I asume this isn’t the hardest formula, but I don’t know how to do it.
Thanks!

[augmented]

Hi Andreas. Something like this might work…

DATETIME_PARSE({Year shown}&’ ‘&Day&’ '&Month, ‘YYYY DD MM’)

Good luck!

[Andreas_Tystad]

Thank you for your reply! But unfortunetaly, it didn’t work… Do you have another solution?

[augmented · Accepted solution]

If you copied it from my reply into Airtable, make sure to fix the single quotes to be '. Straight single quotes.