I have been reading and searching for answer and cannot find it.
But, I have a the function ““ISOweek” and I need to use it in a view, and at the same time set: “set DATEFIRST 1“ so it uses “Europiaen” week number, like thes year, week 53, and then week 1.
How do I do this?
substring(Stat.DBO.ISOyyyyww(SL.CREATEDDATE),5,2) as Order_Week,
Br
JBN