Forum Discussion
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, that shows week 32 of the year 2023
Can you help me with craeting week range in the date column?
Thanks
3 Replies
- Ahmedx
Super User
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
