Save the date! Join us on October 16 for our Product Ops launch event. Register 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).
DATETIME_FORMAT(Date, 'YYYY')
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)
See Solution in Thread