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!
Solved
Create date out of numbered fields
+3Best answer by augmented
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.
Hi Andreas. Something like this might work…
DATETIME_PARSE({Year shown}&’ ‘&Day&’ '&Month, ‘YYYY DD MM’)
Good luck!
+3Hi 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?
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.
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.