Sorry, @anon47149808. It’s in our priority list but we haven’t had the resource to put on this. In the past few months, I’ve been working on formula performance, and I hope you notice the improvements there.
I’ll keep you posted if we have any updates!
well, my suggestion would be to keep the Weekday() for the USA week logic only, use the IsoWeekday() for the Monday as first way of the week (for Saturday or Friday I guess you can come up with function names) and you remove the link with the settings in your doc, because
when I don’t pay attention and I use weekday() in my docs and copy the work to a doc of a client in the USA , the weekday() gets a different meaning. This causes all sorts of problems.
merci!
Cheers, Christiaan
My first foray into this community and I have to say I am loving Coda so far … which makes me all the more perplexed this request has been languishing for so long!!
Hats off to Coda’s team for at least engaging on here rather than letting it fall on deaf ears.
Given it’s been 2 years since it was acknowledged by Coda as "definitely a priority, if I could offer one piece of advice: provide a bit more detail on why it’s such a complex issue and why the seemingly simple suggestions other users have made (e.g. to set a default date format at the document level) won’t work.
If you can do that, it will give us more confidence that you have looked into this and that the resource challenge is genuine (most reasonable users understand and respect the need for you to prioritise resources).
Cheers James
Its a big headache for me as well. Coda’s system doesnt play well with European date format. I spent more than 10 hours figuring out why my filters and formulas werent working…
I agree, let us set it at the doc level. I spent a few minutes wondering why my imported data wasn’t sanitised because it was saying 3-5-22 and me thinking that it should be March, not May. Before realising it was set to US.
At the very least the default for display datas for all Coda files should be clear and unambiguous so if they are to use US formats at least default to displaying March 5 2022, not 3-5-22.
That seems to be another great suggestion. Hopefully Coda can explain why they can’t set at doc-level, or failing that, why they can’t change the US default to the alphabetical month.
(I’m not going to push my luck and ask for alphabetical months to be added for non-US formats as well)
I can’t say anything else but please fix this asap.
It’s simply annoying creating database tables, and everytime I use a date field, I also need to enter options to set the correct format that I want for my Doc.
I simple option in your profile, what is your prefered date format and time format option, and everytime you create a new doc, these settings will be used.
The other good suggestion, is to set the standards, how you want the Doc to be formatted, so everytime you create a new doc, these standards are already set.
Thanks.
It’s the third anniversary of me posting this. When will we be able to set default date display options (and currency for that matter)? Or just be able to format copy and paste columns.
will this ever be implemented… thats terrible!! the topic is open for almost 4 years @Harry_Doan
@Harry_Doan @BenLee Why haven’t we had an update on this? We’ve been through the rise of AI and this still hasn’t been updated?
In September 2022 you said it was in your ‘priority list’ but it doesn’t seem that way.
We are just boarding on Coda (which is a great app) but the lack of global settings for european date formats is really annoying (especially when calling formulas directly in the caneva).
If I could, I would put my 9 votes on this topic. 
One more vote for this. I would like to have simple formats like:
+1 for this. I wonder why such a seemingly simple feature cannot be included as an option in the regional settings. This is not just a UX thing, this can cause BIIIIG problems for someone who doesn’t commonly use US dates.
Hi Harry, is there any update on this? The date formating causes a lot of confusion. Of course, Coda is not the only platform struggling to fix this, but it’s hard to imagine what’s holding you guys from having us the dates displayed in the format we are used to read.
Many thanks for your effort! Coda is otherwise marvelous!
Let people choose any (default) time format and manage data about the days of the week as they like!
Let’s talk!
A little shocked this hasn’t been fixed in several years. At the moment it seems like you can set each individual column to a different format, which is incredibly time consuming, but there is no way to set formula column date format settings. Maye it can be done within the formula, but it’s really adding so much fiddly work to have to figure all this out instead of just being able to set the format once in the global settings and moving on.
Also just pointing out this isn’t a just European issue, it’s almost everywhere outside of USA.
@Harry_Doan any update on the number formatting???
@Harry_Doan how can we change date formats in formulae? ToDateTime() outputs in US format which is no good to my users as it’s confusing.
FormatDateTime() - undocumented, but works good.
I documented this to some extend in my sample document
use “0” (zero) as a parameter to not show a date, resp. not show a time.
