We use weeknumbers to follow projects that can last more than one year. For that reason we always add the year to the weeknumber, like weeknr 1436 for week 36 in 2014 or 1502 for week 2 in 2015 (always four digits).
I think I can manage with a string concatenation to create weeknr 1436, but how do I create weeknr 1502 (four digits) instead of 152 when using the DatePart function?

---

Reply from Alex Hedley:

Rich covers this later in the video.
Just use the Format function with "00" to show 2 numbers and use concatenation (&) to join them to your year