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
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
Both GSheets and Glide give me 39.
Just read the following in the GDoc reference:
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.
@Darren_Murphy thanks. Which week number do you have in Singapore? Is this truly week 39?
In Denmark it is week 38
@Darren_Murphy ah. I’m in system 2. ISO week numbering.
I’m not aware glide can do this week numbering - are you?
Maybe due to difference between time zones?
Well, system 2 also gives me 39…
Looks like Glide may not support specifying which system to be used, at least not with the same syntax…
Given that System 2 is ISO standard, I would hope (and expect) that to be the default. But, who knows?
The week number in Europe is 38 - and not 39😕
Yes, you’re right.
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
The function to use in google sheets is isoweeknum
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
This site is also a great reference for time-related things:
https://www.timeanddate.com/date/weeknumber.html
I’ll look into it.
Glide’s implementation is correct:
We don’t have isoweeknum
yet, sorry.
Well, then the implementation isn’t really useful for me in Europe. This is a pity.
I might have to rely on google sheets