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
Jul 08, 2019 08:47 AM
Hello,
I have a base that has the date and time in one field, I have created another field and I would like to have that field enter the YYYY from the date time field using a formula.
Would anyone know what the formula would be?
Thanks in Advance!
Solved! Go to Solution.
Jul 08, 2019 08:57 AM
You can use either of these:
YEAR({Date Field})
or
DATETIME_FORMAT({Date Field}, 'YYYY')
Jul 08, 2019 08:57 AM
You can use either of these:
YEAR({Date Field})
or
DATETIME_FORMAT({Date Field}, 'YYYY')
Jul 08, 2019 09:36 AM
Thanks Kamille - You’re Awesome!