How to convert this to Date

[venkatasuresh_g]

Hi,

 How can I convert this to a Date "18-WK01" , which is 2018-Week01

Thanks for your help

Suresh Guddanti

[az38 · Accepted solution]

Hi @venkatasuresh_g 

if you need to show Mondays of each week try this column

Column = 
var _startYear= DATE(2000 + VALUE(LEFT([Date],2)),1,1)
var _startDay = IF(WEEKDAY(_startYear,1) = 2, _startYear + 7*(VALUE(RIGHT([Date],2)) - 1), _startYear + 7*VALUE(RIGHT([Date],2)))
RETURN
_startDay - WEEKDAY(_startDay,2) +1

[venkatasuresh_g]

Thank you so much