Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Month week

I need to calculate week no month wise. Date    Week No 1-7       1 8-14     2 15-21   3 22-28   4 29-31   5   Please help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous ,

    Try in your date table

    Month Start Date = startofmonth([Date])

    Month Week = Quotient(datediff([Month Start Date],[Date],Day),7) +1

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous ,

Try in your date table

Month Start Date = startofmonth([Date])

Month Week = Quotient(datediff([Month Start Date],[Date],Day),7) +1