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
Dec 01, 2021 01:46 AM
I extract only year from date field with DATETIME_FORMAT(Date, 'YYYY')
and assign it to new field.
If I order by that field it isn’t recognized as number, but as a string (the option is A-Z or Z-A).
How can I change it to a number?
Solved! Go to Solution.
Dec 01, 2021 03:03 AM
Welcome to the community, @Edoardo_StefaniL!
Use the YEAR function instead:
YEAR(Date)
Dec 01, 2021 03:03 AM
Welcome to the community, @Edoardo_StefaniL!
Use the YEAR function instead:
YEAR(Date)