Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Create date out of numbered fields

Topic Labels: Formulas
Solved
Jump to Solution
263 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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.