Forum Discussion
Solved
Convert Week number into date
Hi All, How can I convert week no into date ? So that I can use that in continuous X-Axis of my visual. Thanks, Arul
Arul , Assume you have Year and week no with you
New column =
var _st = date([Year],1,1)
var _st_week = _st - weekday(_st ,2) +1 //monday week
return
_st_week + (7 *[week no])
Arul , Assume you have Year and week no with you
New column =
var _st = date([Year],1,1)
var _st_week = _st - weekday(_st ,2) +1 //monday week
return
_st_week + (7 *[week no])
It helps. Thank you