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

WEEKNUM() day

Posted on 10-20-2020 09:12 AM
1minManager
Gold 4
Gold 4
Reply posted on --/--/---- --:-- AM

For WEEKNUM(), does a week begin on Sunday or Monday? The help page doesn’t specify and I’ve got a Report running on Sunday at 1200 that checks if a record has already been created manually.

0 5 250
Topic Labels
0 Likes
5 REPLIES 5

Posted on --/--/---- --:-- AM
JuneCorpuz
Gold 1
Gold 1
Reply posted on --/--/---- --:-- AM

WEEKNUM() shows the week number not the number for a specific day

0 Likes

Posted on --/--/---- --:-- AM
1minManager
Gold 4
Gold 4
In response to JuneCorpuz
Reply posted on --/--/---- --:-- AM

Let me put it another way

Is Sunday 25th Oct 2020 in week 43 or week 44?

As WEEKDAY() has Sunday as day 1

0 Likes

Posted on --/--/---- --:-- AM
JuneCorpuz
Gold 1
Gold 1
In response to 1minManager
Reply posted on --/--/---- --:-- AM

Week 44

3X_9_6_96610d0fd3a64a416d3ad000351ea2929e860183.png

0 Likes

Posted on --/--/---- --:-- AM
1minManager
Gold 4
Gold 4
Reply posted on --/--/---- --:-- AM

So WEEKDAY() starts on a Sunday and WEEKNUM() Starts on a Monday

0 Likes

Posted on --/--/---- --:-- AM
JuneCorpuz
Gold 1
Gold 1
In response to 1minManager
Reply posted on --/--/---- --:-- AM

WEEKNUM() starts on a sunday. See screenshot below

3X_5_1_51e618acddd0a6ca7709aaacbf70d22eef34e59b.jpeg
3X_2_0_20cd6308a47dcdfba97109eb79e2eb79ae39f20e.jpeg

0 Likes
Top Labels in this Space