Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Need Help on creating weeks with months

Hi,   I am working on a data set where the date range is defined by the week number of the specific year.  For example: 1) If its 202205,that shows week number 5 of the year 2022 2)If its 202332...
Need Help
Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
3 years ago

pls try this

startweek date = 
var _year = VALUE(LEFT([Year-week],4))
var _week = VALUE(RIGHT([Year-week],2))
VAR _date = DATE(_year,1,-2)-WEEKDAY(DATE(_year,1,3))+_week*7
RETURN
_date-7

-----------------

Endweek date = 
var _year = VALUE(LEFT([Year-week],4))
var _week = VALUE(RIGHT([Year-week],2))
VAR _date = DATE(_year,1,-2)-WEEKDAY(DATE(_year,1,3))+_week*7
RETURN
_date