MacOs Ventura and date format issue
Hi, I've downloaded MacOS Ventura and date format has changed. All dates are now with this format : "4 nov.2022" instead of "04/11/2022" .
MacOs Ventura System Settings do not permtit now to choose the right date format : https://support.apple.com/en-au/guide/mac-help/mh27073/13.0/mac/13.0
Does anyone has a solution ?
7 replies
-
Following the directions on this page would look something like:
format(datefield,"MM/DD/YYYY")
You will need to click on the link at the bottom to see the date and time formats.
-
Hi Fred Thanks a lot for your answer. I have many many fields on my database with a date field. So I was looking for an other solution to format all my database with one date format. I thinks Ninox need to make an update according to the new MacOS version
-
You will probably get support for dates in the year of 2025. Don't hold your breath.
-
I have never seen Ninox addresses any issue. I submitted so many issues, errors, etc., to them. Not a single one has been addressed. Not even serious bugs.
-
Hi ,
Though your question was posted a long time ago, I still want to share the solution I found for this issue. It might help you and other Ninox users.
Background:
The "problem" with the date format changing in the Ninox app after updating to macOS Ventura is caused by Apple. While they changed the macOS settings panel, they removed the option to easily edit date/time formatting. Whoops! It looks like Ninox relies heavily on the medium time format for your date field, and guess what: that one is not easy to change with the new macOS settings. It would be nice if Ninox would change this in the future, so it's not depending on this setting anymore, but for now this is the cards we're dealing with.
Solution:
I found some info on this Reddit page, so credits to the folks over there. There was more information, but it's not on that page anymore. I did make a copy of it and I'll add this extra info after the Solution.
First of all: make sure you know what you're doing once you start digging into macOS with the Terminal!
Go to the macOS terminal and enter the following, then hit enter:
defaults write -g AppleICUDateFormatStrings -dict 2 'dd-MM-yyyy'
The 'dd-MM-yyy' dictates what the format is. If you want to use another format, please find the extra info below.
Extra info:
(I copied and saved this information without a link to the original poster, so unfortunately I'm not able to credit the right person anymore.)
This is a case of "everything old is new again". In Tiger or Leopard (I forget!) Apple removed the Advanced time/date format settings, so we all had to learn how to set them manually. Then, one or two major versions later, they added it back again. Anyway…
You're looking at setting at least three keys in the
NSGlobal
domain:AppleICUNumberSymbols
AppleICUDateFormatStrings
AppleICUTimeFormatStrings
They're all dictionaries. (Some of) the possible keys of
AppleICUNumberSymbols
are:0
— decimal separator for numbers1
— thousands separator for numbers4
— starting character for digits8
— currency symbol10
— decimal separator for currency17
— thousands separator for currency
Example: If want to use a space as thousands separator and a
.
as decimal separator, you have to do:defaults write -g AppleICUNumberSymbols -dict 0 '.' 1 ' ' 10 '.' 17 ' '
(Note the
-g
flag to specify the global domain!)AppleICUDateFormatStrings
has four possible keys:1
— short date format2
— medium date format3
— long date format4
— date date format
So, to set the short date in ISO8601:
defaults write -g AppleICUDateFormatStrings -dict 1 'y-MM-dd'
(I may be wrong about the exact format; please go and look it up in the ICU Documentation!)
AppleICUTimeFormatStrings
works analogously toAppleICUDateFormatStrings
.You may or may not need to log out and back in — or even reboot? — after making these settings. Note that the values in the dropdown menus in System Settings will not change, but the bit of grey example text in the "Language & Region" panel showing the dates and times will change to reflect your new formats.
Sources of information:
Content aside
-
2
Likes
- 10 mths agoLast active
- 7Replies
- 772Views
-
5
Following