# Weeknum - wrong number **URL:** \ **Category:** Ask for Help\ **Created:** [September 24, 2021, 12:18pm UTC](https://community.glideapps.com/t/weeknum-wrong-number/32268 "2021-09-24T12:18:15Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\ **Post date:** [September 24, 2021, 12:18pm UTC](https://community.glideapps.com/t/weeknum-wrong-number/32268/1 "2021-09-24T12:18:16Z")
Trying to use weeknum math function Trying to get weeknumber for date 24-09-2021 Glide says it is week 39. Google sheets says it is week 38 (which is correct) Is this a bug or are weeknumbers different around the world. I don’t get it ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 24, 2021, 12:28pm UTC](https://community.glideapps.com/t/weeknum-wrong-number/32268/2 "2021-09-24T12:28:21Z")
Both GSheets and Glide give me 39. ![Screen Shot 2021-09-24 at 8.27.03 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/7/073c8ee92b18b282b571327d92363a04ca010145.png) ![Screen Shot 2021-09-24 at 8.27.33 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/1/51c9196480b8a81e2c9de3357f48013efb6c056e.png) Just read the following in the GDoc [reference](https://support.google.com/docs/answer/3294949?hl=en): ```auto Behind the scenes, there are two week numbering "systems" used for this function: System 1 - The first week of the year is considered to be the week containing January 1, which is numbered week 1. System 2 - The first week of the year is considered to be the week containing the first Thursday of the year, which is numbered as week 1. System 2 is the approach specified in ISO 8601, also known as the European system for numbering weeks. ``` Not sure if that makes any difference in your case. ---
**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\ **Post date:** [September 24, 2021, 12:30pm UTC](https://community.glideapps.com/t/weeknum-wrong-number/32268/3 "2021-09-24T12:30:30Z")
@Darren_Murphy thanks. Which week number do you have in Singapore? Is this truly week 39? In Denmark it is week 38 ---
**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\ **Post date:** [September 24, 2021, 12:32pm UTC](https://community.glideapps.com/t/weeknum-wrong-number/32268/4 "2021-09-24T12:32:10Z")
@Darren_Murphy ah. I’m in system 2. ISO week numbering. I’m not aware glide can do this week numbering - are you? ---
**Author:** ![phong\_tran](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/phong_tran/32/32160_2.png) [@phong\_tran](https://community.glideapps.com/u/phong_tran)\ **Post date:** [September 24, 2021, 12:36pm UTC](https://community.glideapps.com/t/weeknum-wrong-number/32268/5 "2021-09-24T12:36:35Z")
Maybe due to difference between time zones? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 24, 2021, 12:36pm UTC](https://community.glideapps.com/t/weeknum-wrong-number/32268/6 "2021-09-24T12:36:58Z")
Well, system 2 also gives me 39… ![Screen Shot 2021-09-24 at 8.33.34 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/a/7a4c6cbb4c7cac72a1035c060ee7dc24482cc3f8.png) Looks like Glide may not support specifying which system to be used, at least not with the same syntax… ![Screen Shot 2021-09-24 at 8.34.50 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/1/a1fb3c577abd9e6868cc96f93d9bbd0e5c00aff0.png) Given that System 2 is ISO standard, I would hope (and expect) that to be the default. But, who knows? 🤷‍♂️ ---
**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\ **Post date:** [September 24, 2021, 1:47pm UTC](https://community.glideapps.com/t/weeknum-wrong-number/32268/7 "2021-09-24T13:47:43Z")
The week number in Europe is 38 - and not 39😕 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 24, 2021, 1:52pm UTC](https://community.glideapps.com/t/weeknum-wrong-number/32268/8 "2021-09-24T13:52:55Z")
Yes, [you’re right](https://www.epochconverter.com/weeks/2021). I can only assume that Glide starts counting from Jan 1 (System 1). The thing I don’t get is why the GSheet weeknum() function gives me 39 for both system 1 and system 2. But I’m not going to lose any sleep over it 😃 ---
**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\ **Post date:** [September 24, 2021, 4:35pm UTC](https://community.glideapps.com/t/weeknum-wrong-number/32268/9 "2021-09-24T16:35:26Z")
The function to use in google sheets is isoweeknum [https://support.google.com/docs/answer/7368793?hl=en](https://support.google.com/docs/answer/7368793?hl=en) @mark is this function actually available in glide? So you can get the iso week number. This is what I need when living in Europe ---
**Author:** ![BlakeWS](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/blakews/32/24377_2.png) [@BlakeWS](https://community.glideapps.com/u/BlakeWS)\ **Post date:** [September 24, 2021, 5:18pm UTC](https://community.glideapps.com/t/weeknum-wrong-number/32268/10 "2021-09-24T17:18:44Z")
This site is also a great reference for time-related things: [https://www.timeanddate.com/date/weeknumber.html](https://www.timeanddate.com/date/weeknumber.html) ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [September 25, 2021, 4:44pm UTC](https://community.glideapps.com/t/weeknum-wrong-number/32268/11 "2021-09-25T16:44:19Z")
I’ll look into it. ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [September 26, 2021, 5:54pm UTC](https://community.glideapps.com/t/weeknum-wrong-number/32268/12 "2021-09-26T17:54:16Z")
Glide’s implementation is correct: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/2/f207ef5aaee773c1c6a55e1c3c78bea6ed487151.png) We don’t have `isoweeknum` yet, sorry. ---
**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\ **Post date:** [September 26, 2021, 6:15pm UTC](https://community.glideapps.com/t/weeknum-wrong-number/32268/13 "2021-09-26T18:15:38Z")
Well, then the implementation isn’t really useful for me in Europe. This is a pity. I might have to rely on google sheets ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 17, 2024, 4:50pm UTC](https://community.glideapps.com/t/weeknum-wrong-number/32268/14 "2024-01-17T16:50:24Z")