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.
David
shared this idea
Sorry for the delay in getting back to you on this issue. We’re currently investigating why you are seeing the US date format.
8 comments
-
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.
-
Mike
commented
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). -
Ahmet
commented
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.
-
Matt
commented
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 ?
-
David
commented
Are you ever going to fix this? Invoicing is of no use until you do.
-
David
commented
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.
-
David
commented
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.