2

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

null
    • Fred
    • 2 yrs ago
    • Reported - view

    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.

    • Emeric_Leroux
    • 2 yrs ago
    • Reported - view

    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

      • Emeric_Leroux
      • 2 yrs ago
      • Reported - view

      One more details, on the web version date format is ok !  The issue in only on the app version.

    • Nick_Massie
    • 2 yrs ago
    • Reported - view

    You will probably get support for dates in the year of 2025.  Don't hold your breath.  

    • NetSol Co., Ltd.
    • Bernd_Krell
    • 1 yr ago
    • Reported - view

    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.

    • Youri_Penders
    • 10 mths ago
    • Reported - view

    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 numbers

    • 1 — thousands separator for numbers

    • 4 — starting character for digits

    • 8 — currency symbol

    • 10 — decimal separator for currency

    • 17 — 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 format

    • 2 — medium date format

    • 3 — long date format

    • 4 — 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 to AppleICUDateFormatStrings.

    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:

      • Fred
      • 10 mths ago
      • Reported - view

      They also did this with WiFi networks order. You use to be able to change the join preference of WiFi networks. That is now gone in Sonoma (v14).

Content aside

  • 2 Likes
  • 10 mths agoLast active
  • 7Replies
  • 781Views
  • 5 Following