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, that shows week 32 of the year 2023

 

Can you help me with craeting week range in the date column?

 

Thanks

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Can you please explain with a example. Do you need each month week number ? if you provide any example that would be better to understand 

  • 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