Hello,
I have an issue with the ISOWEEKNUM function.
I have a table where I want to extract a "YEAR - WEEK" column from a @DATE column, using this formula:
=YEAR([@Date])&"-"& ISOWEEKNUM([@Date])
However, for 01-01-2022 I get 2022-52. Technically this is right since I concatenate two numbers that are right on their own.
I would like to order this column in the right sequence though.
How can I achieve that?
Thanks...
Bookmarks