This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Help with Weeknum() Function

Posted on 10-02-2021 08:58 AM
Muhammad_Rafif
New Member
Reply posted on --/--/---- --:-- AM

how to make the weknum function only read in that month
example if i put a [date] column are 10/2/2021 then the weeknum is 1 not 40

Solved Solved
0 5 261
Topic Labels
Jump to Solution
0 Likes
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
Steve
Platinum 5
Platinum 5
Reply posted on --/--/---- --:-- AM

Try this:

SWITCH(
  EOWEEK([date]),
  EOWEEK(EOMONTH([date], -1) + 1),
    1,
  EOWEEK(EOMONTH([date], -1) + 1 + 7),
    2,
  EOWEEK(EOMONTH([date], -1) + 1 + 14),
    3,
  EOWEEK(EOMONTH([date], -1) + 1 + 21),
    4,
  5
)

View solution in original post

Jump to Solution
5 REPLIES 5
Top Labels in this Space