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
Extract Year from a Date Field
+12Best answer by Kamille_Parks11
You can use either of these:
YEAR({Date Field})
or
DATETIME_FORMAT({Date Field}, 'YYYY')
+27You can use either of these:
YEAR({Date Field})
or
DATETIME_FORMAT({Date Field}, 'YYYY')
+19You can use either of these:
YEAR({Date Field})
or
DATETIME_FORMAT({Date Field}, 'YYYY')
Thank you for this, how would I go about getting the Month (name not number) = as similar formula
We organize our reports rollup by month. I have a manual method right now but I would love to have an automated formula that created JAN/FEB/MAR etc so when I create a report - it prints out the Month Name not the Month Number
+20
How does one extract the year from a Last modified field?
+31Try using ‘YY’ instead, e.g.
DATETIME_FORMAT(LAST_MODIFIED_TIME(), 'YY')
Here’s the list of supported modifiers: https://support.airtable.com/docs/supported-format-specifiers-for-datetime-format
Adam, Airtable Consultant - thetimesaving.company
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.