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!
Yeah, it’s really disappointing that Airtable is so unusable outside of the USA, and it doesn’t seem like the Airtable team is too bothered by this. They seem to have no concept that 80% of the world starts their weeks on a different day than Sunday, and that 80% of the world doesn’t format currency or phone numbers like the USA.
You can’t change the date picker, you can’t change the week number function, and you can’t change calendar views. I suppose that you could PARTIALLY solve the calendar views situation by creating a calendar subscription link and then subscribing to it in an external calendar app (such as Outlook or BusyCal), but that still doesn’t fix the date picker or the week number formulas.
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.
