The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
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?