Use the date format from settings
The date on invoices is in US format - MM/DD/YY - even though I have my location correctly set as UK. I think is a bug rather than a feature but it needs to be fixed as customers are given a date which can have an impact on when they pay.
Sorry for the delay in getting back to you on this issue. We’re currently investigating why you are seeing the US date format.
Steve K commented
Currently, depending on what I am looking at via the MS admin portal, the date formats are a mixture of DD-MM-YY and MM-DD-YY. Like this, is is impossible to tell at a glance what date it is. it needs careful scrutiny by comparing these dates against all other documents. This is made worse because, when the year 2019 is represented by only ’19’, I first assume that is the 19th of the month because my usual format is YYYY-MM-DD. The format YYYY-MM-DD should be shown for the benefit of an international cliental. Like this, it cannot be construed mistakenly as anything else. Please change the format to only YYYY-MM-DD.
We have the same issue with Excel Online using US date format which is confusing our users especially when they have created the spreadsheet in Desktop version of Excel 365 which formats UK dates correctly...then there's the time zone issue with SharePoint always using PST when we are GMT
Margarita Andreeva commented
Hello, I have the same problem. The date stamped on the e-mail of the invoice is in US format. Could you please change it to UK for me, or advise how it can be done?
My online profile regional settings are set to English (UK).
Date format doesn't work on 365 whatever you do. Everything comes up in the US format. You'd think that date is one of the simplest things excel should be able to handle. Scandalous.
I get exactly the same problem and my language and keyboard layout is set to UK in Windows and in my browsers. Are there any updates on this issue ?
Are you ever going to fix this? Invoicing is of no use until you do.
Further information on this. In the invoices list, the dates are shown in the correct local format - DDMMYY in this case - but the invoices editing screen shows the US format - MMDDYY - as do the invoices themselves when sent to the customer. So it looks like the settings are being picked up but are not being applied correctly.
Thanks for responding. I don't thing Edge has separate browser language preferences as far as I can see? All the setting I can find - Office 365, Business Center and Windows 10 Control Panel are correct. Also, the same issue is happening when I create an invoice in iPhone app. It would be very much appreciate it if you could fix this, as it the date confusion makes Invoicing pretty much unusable.