Help

Create date out of numbered fields

Topic Labels: Formulas
Solved
Jump to Solution
683 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Andreas_Tystad
5 - Automation Enthusiast
5 - Automation Enthusiast

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!
8505f2773923036a75f069abb998fbea

1 Solution

Accepted Solutions

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

See Solution in Thread

3 Replies 3
augmented
10 - Mercury
10 - Mercury

Hi Andreas. Something like this might work…

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

Good luck!

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

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