WEEKNUM - every 10 week 6 digits

[ddlyturtle]

Hi,

I did use weeknum on my calendar table and it was mostly correct, but also incorrect in some places. So I'll probably have to remake, but I still want to understand the issue.

But the absolute strangest thing that has occured is that every 10 week (10, 20, 30, 40 and 50) is a 6 digit number and increment for each day during that week. Any reason this might happen?

For example 136584 is monday on week 10, while 136585 is tuesday etc.

week 7, 8, 9, 136584, 11

Any explanation?

 

[My Aswer Is This]

How do you come to the conclusion that 136584 equals Monday

 

[ddlyturtle]

How do you come to the conclusion that 136584 equals Monday

Well simple answer is I do have columns DATE/YEAR/MONTH/DAY/QUARTER/WEEK. On the week column I had 7 rows of each weeknum obviously. But as week 10 "starts" (always monday) instead of having "10" written out, i have a 6 digit number (and above was an example for.. week 10 in mars 2000?
FORMAT ( [Date];WEEKNUM([Date];2)

But as i said; that week 10 20 30 40 50 doesnt "exist" instead is replaced by some 6 digit value which is +1 for every day that week. But week 1-9 11-19 21-29 etc does show up normally.


To note tho, I did scrap this column, just interested if anyone had any similar issue and explanation what may've been.