Converting week W53 12 2020 to "Dec-2020"

[harirao]

Hello Team,

Can you please assist me how to convert weeks i.e W53 12 2020 to "Dec-2020", tried using Format its not working, data type  from source is "TEXT"



Thank you

Regards,

[amitchandak]

@harirao ,

In a new column like

if(SEARCH("W53",[Weeks],,0)>0, "Dec " & right([Weeks],4),[Weeks])

[harirao]

Hi @amitchandak,

Thanks for your quick response, it is working for one row, is it possible to use month mentioned in row Eg "W53 12 2020", can use only 12, 11, 10 for converting month format?

Thanks for your help

Regards,

[amitchandak · Accepted solution]

@harirao , You can create a date as a

Week to Date = var _st = date(right([Weeks],4),1,1)
var _week = mid([Weeks],2,2)*1
Return _st+((_week-1)*7) -WEEKDAY(_st,2)+1

From the date you can get any format

Year of the month to format([Week to Date] ,"MMM YYYY")