Splitting Year from YearWeek

[s4ni9r]

Dear All,

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

WeekYear

2021-01

2021-02

2021-52

2021-53

[NitinK7]

try below

Subfield(YearWeek,'-',1) as Year

Subfield(YearWeek,'-',2) as Month

[s4ni9r]

the second value after '-' is actually week, but i want in Year as seperate field and Month as seperte field using YearWeek as source field

[PrashantSangle]

Hello,

use makeweekdate() to convert you week into date and then from date you can easily get month & year

try like

Month(makeweekdate(left(WeekYear,4),right(weekYear,2))) as Month,

left(WeekYear,4) as Year,

Regards,

Prashant Sangle

[s4ni9r]

ThankYou Very Much PrashantSangle Sir

[PrashantSangle]

if it work for you then like that solution and select accept as solution.

[s4ni9r · Accepted solution]

Sure PrashantSangle Sir