Hi all!
I’m just posting to give the Europeans on here a tip, because I was searching here and got no result.
I’ve been struggling with trying to get a week number in a BAQ and it kept returning the week number in America, which is different then the week number in Europe.
Instead of using Datepart(week, … ) you should use Datepart(ISOwk, …. )
4 Likes