I have YearWeek, which shows values as shown below, i want to separate this into two different columns.
1. Year 2. Month, Could you please help me , how to get Year seperatly and Month Speratley
use makeweekdate() to convert you week into date and then from date you can easily get month & year
Month(makeweekdate(left(WeekYear,4),right(weekYear,2))) as Month,
left(WeekYear,4) as Year,