When you use a date picker for entering date in date field its always a Sunday as a week start day. Would be great to have ability to change it. Thanks!
Philipp_Jakob wrote:
Worst thing for me sitting in Europe:
If you use the weeknum() function to generate week numbers from dates and then you group by those week numbers, it will include sundays in the, at least from a european perspective, wrong week.
Every calendar app wanting to be international offers this option. It’s a matter of global thinking.
Greetings
Phil, Europe, Switzerland
It’s a bit of a hack, but for my purposes, the following simple formula has been useful for grouping:
WEEKNUM(Date) - IF(WEEKDAY(Date) = 0, 1, 0)
+7Lasse_Kokholm wrote:
It’s a bit of a hack, but for my purposes, the following simple formula has been useful for grouping:
WEEKNUM(Date) - IF(WEEKDAY(Date) = 0, 1, 0)
Would you mind stepping me through this formula. Total newbie here and can’t quite figure out how it works. It’s returning what I want it to, but want to make sure it’s relevant/accurate for me longterm. Thank you!
Meagan_Caesar wrote:
Would you mind stepping me through this formula. Total newbie here and can’t quite figure out how it works. It’s returning what I want it to, but want to make sure it’s relevant/accurate for me longterm. Thank you!
Sure! The formula converts the US week number to an EU week number. WEEKNUM(Date) returns the US week number; at the time of this writing, it will return 8, and this coming Sunday, it will return 9. The latter is an incorrect EU week number, since the next week does not start until Monday. So the formula simply subtracts 1 from the week number on a Sunday, which is determined by WEEKDAY(Date) = 0, here 0 denoting the first US day of the week, i.e. Sunday. It is a hack in the sense that I threw it together without considering all possible future corner cases; calendar dates can be quite complicated.
Hope that helps!
+7Lasse_Kokholm wrote:
Sure! The formula converts the US week number to an EU week number. WEEKNUM(Date) returns the US week number; at the time of this writing, it will return 8, and this coming Sunday, it will return 9. The latter is an incorrect EU week number, since the next week does not start until Monday. So the formula simply subtracts 1 from the week number on a Sunday, which is determined by WEEKDAY(Date) = 0, here 0 denoting the first US day of the week, i.e. Sunday. It is a hack in the sense that I threw it together without considering all possible future corner cases; calendar dates can be quite complicated.
Hope that helps!
Thank you for taking the time to explain. Definitely makes sense and I appreciate the workaround!
+7Lasse_Kokholm wrote:
Sure! The formula converts the US week number to an EU week number. WEEKNUM(Date) returns the US week number; at the time of this writing, it will return 8, and this coming Sunday, it will return 9. The latter is an incorrect EU week number, since the next week does not start until Monday. So the formula simply subtracts 1 from the week number on a Sunday, which is determined by WEEKDAY(Date) = 0, here 0 denoting the first US day of the week, i.e. Sunday. It is a hack in the sense that I threw it together without considering all possible future corner cases; calendar dates can be quite complicated.
Hope that helps!
Thanks again! One more question… I’ve found this formula that suits my needs a little more, but I’m unsure how to adjust it so that Sunday is the last day of the week and Monday the first. If you have any suggestions I’d very much appreciate them.
CONCATENATE(“Week of”," ",DATETIME_FORMAT(DATEADD({Date},-DATETIME_FORMAT({Date},‘e’),‘days’),‘D/M’))
+4I wonder how Airtable users are distributed around the globe.
As a European it is so easy to pick the wrong date on a calendar that starts with Sundays.
Getting requests now from dutch people (who like to have their phone language in english) that want Mondays to be the leftmost date instead of Sundays in the calendar picker in an Airtable form. I now need to tell them to change their entire phone settings just for some Airtable form.
+4Christiaan_West wrote:
I wonder how Airtable users are distributed around the globe.
As a European it is so easy to pick the wrong date on a calendar that starts with Sundays.
Getting requests now from dutch people (who like to have their phone language in english) that want Mondays to be the leftmost date instead of Sundays in the calendar picker in an Airtable form. I now need to tell them to change their entire phone settings just for some Airtable form.
Everybody, we need your help! Can you please fill out this Airtable form in your browser and register the first day you see in the date pickers?
I’ve found a fix for the Mac app. I have my region as Denmark, but language as English - US in my system preferences. But you can change the language per app, so if I change that for Airtable to English (UK) or something else, it’ll do it right and you’re not forced to have another language as the primary language on the whole computer
A bit confusing in Europe :slightly_smiling_face:
In datepicker, but also Calendar View…
#bump
later edit:
As a workaround for Calendar View, there are Chrome/Edge browser extensions that can help in changing the browser locale. For me, it worked for the Calendar View, changing the first week day to monday, but did NOT fix it for the Date Picker input.
+1
Planning a week of work from Monday to Sunday would be a key functionality of my project.
Finding this limitation after an hour of learning this product (as developer) is bit scary.
The negligence of an important topic (like this) also leave some question marks…
+1 we are a global company and I believe having the week start on Sunday is confusing and not user friendly for most people around the world.
+4Could use this feature. A client of ours uses Monday as the first day of the week and our invoices won't match their reporting.
+4Seriously Airtable, get your stuff together. We're not all in the US, it's the most confusing thing to wrap your brain around - how can week start on Sunday?
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.