Solved Can no longer format date as dd/mm/yyyy in Excel (Office 365)


robgr

Active member
Local time
12:07 PM
Posts
83
OS
Windows 11
I have just noticed that appear to no longer be able to format the date as dd/mm/yyyy in Excel (Office 365)
A previous document that had a date cell as =TODAY() and which displayed the date as dd/mm/yyyy is now displaying as 20,11,2021 (current format setting)
However, there is no format type for dd/mm/yyyy when I attempt to reformat the cell back to dd/mm/yyyy
This is the same for any empty cell that I attempt to enter a date for and for new worksheets too
This may have changed with 22504.1000
What am I missing?
 

My Computer

System One

  • OS
    Windows 11
    Computer type
    PC/Desktop
    Manufacturer/Model
    PCSpecialist
    CPU
    Intel(R) Core(TM) i7-1070
    Motherboard
    TUF GAMING B460-PLUS
    Memory
    32 GBytes DDR4-2667 (1333 MHz)
    Graphics Card(s)
    NVIDIA GeForce GT 1030
    Sound Card
    ONBOARD 6 CHANNEL (5.1) HIGH DEF AUDIO (AS STANDARD)
    Monitor(s) Displays
    Samsung U32J590UQU
    Screen Resolution
    4k
    Hard Drives
    SYSTEM Win 10 237.22GB SSD Disk 0 238.47GB M2 (mobo)
    DATA Data 931.41GB HD 2.5" Disk 1 931.51GB SATA3
    BACKUPS Backups 2TB HD 3.5" Disk 2 2TB SATA3
    PSU
    CORSAIR 550W CV SERIES™ CV-550 POWER SUPPLY
    Case
    PCS 3601 CASE
    Cooling
    CoolerMaster Hyper 212 (120mm) Fan CPU Cooler Black Edition
    Internet Speed
    57/18 Mbps
    Browser
    Vivaldi
    Antivirus
    Kaspersky Total Security

rpetruzz

Active member
Local time
7:07 AM
Posts
6
OS
Windows 11 Pro X64 21H2
I just tried to figure this out myself...... It appears that you now need to change the "Locale" in the format cells dialog box.
I was able to change to English (United Kingdom) and it offered me a whole different set of formatting options to use to format the cell.

1637411352861.png1637411426262.png
 

My Computers

System One System Two

  • OS
    Windows 11 Pro X64 21H2
    Computer type
    PC/Desktop
    Manufacturer/Model
    DIY Build
    CPU
    AMD Ryzen 7 3800X
    Motherboard
    ASUS ROG STRIX X570-E GAMING
    Memory
    Corsair DDR4-2132 4x16gb Dual Channel
    Graphics Card(s)
    NVIDIA GeForce RTX 3080TI
    Sound Card
    On motherboard
    Monitor(s) Displays
    2 - NEC PA241W
    Screen Resolution
    1920X1200
    Hard Drives
    1 - WD_BLACK 1TB SN850X NVMe Internal Gaming SSD Solid State Drive - Gen4 PCIe, M.2 2280
    1 - WD_BLACK 2TB SN850X NVMe Internal Gaming SSD Solid State Drive - Gen4 PCIe, M.2 2280
    PSU
    850 Watt Corsair® RM850x 80+
    Case
    Maingear ATX
    Cooling
    Wraith Prism cooler
    Keyboard
    Microsoft Sidewinder
    Mouse
    Logitech
    Internet Speed
    Spectrum - 300mbs
    Browser
    Chrome
    Antivirus
    Windows Defender
  • Operating System
    Windows 10 Pro X64 21H1
    Computer type
    Laptop
    Manufacturer/Model
    Maingear Element
    CPU
    Intel Core i7 9750H
    Motherboard
    Intel LAPQC71B
    Memory
    32gb - Kingston DDR4 1333 Mhz Dual channel
    Graphics card(s)
    NVIDIA GeForce RTX 2070 Max Q
    Sound Card
    On board
    Monitor(s) Displays
    LCD
    Screen Resolution
    1920x1080
    Hard Drives
    2tb INTEL SSD PEKNW020T8
    PSU
    On board
    Case
    Laptop
    Cooling
    Fans
    Mouse
    TeckNet
    Keyboard
    On Board
    Internet Speed
    Spectrum 200mbps
    Browser
    Chrome
    Antivirus
    Windows Defender

jvickers

The lunatics have taken over the asylum
Guru
VIP
Local time
7:07 AM
Posts
6,180
Location
Deep South, USA
OS
Windows 11 Pro
I just tried to figure this out myself...... It appears that you now need to change the "Locale" in the format cells dialog box.
I was able to change to English (United Kingdom) and it offered me a whole different set of formatting options to use to format the cell.

View attachment 14150View attachment 14151
Well, that does make a little sense since dates are typically formatted month/day/year in the U.S. Glad you kind of solved the problem! Day-month-year (like 20-Nov-2021) without switching the locale.
 

My Computers

System One System Two

  • OS
    Windows 11 Pro
    Computer type
    PC/Desktop
    Manufacturer/Model
    Home built
    CPU
    Ryzen 9 5900X
    Motherboard
    MSI MPG X570 GAMING EDGE WIFI
    Memory
    Crucial Ballistix Sport LT 3200 MHz DDR4 DRAM Desktop Gaming Memory 32MB
    Graphics Card(s)
    ZOTAC RTX 3060 Twin Edge OC/ ZOTAC Gaming GeForce GTX 1660 Super 6GB GDDR6 192-bit Gaming Graphics Card
    Sound Card
    Proprietary
    Monitor(s) Displays
    ViewSonic XG2530 25"/Benq XL2411P 24"/ Samsung SyncMaster BX2331 23"
    Screen Resolution
    1920x1080 240Hz/144Hz/60Hz (based on monitor setup above)
    Hard Drives
    SK hynix Gold P31 1TB PCIe NVMe Gen3 M.2 2280 Internal SSD
    ADATA XPG SX8200 Pro 1TB
    Samsung SSD 860 EVO 1TB 2.5 Inch SATA III Internal SSD
    PSU
    Thermaltake Smart 700W 80+ White Certified PSU
    Case
    Rosewill ATX Mid Tower Gaming Computer Case, Gaming Case with Blue LED for Desktop
    Cooling
    Corsair iCUE H60i RGB PRO XT Liquid CPU Cooler
    Keyboard
    Corsair K70
    Mouse
    Logitech MX Master 3
    Internet Speed
    120MB/s Download/ 10MB/s Upload
    Browser
    Edge (Chromium)
    Antivirus
    Norton 360
  • Operating System
    Windows 10
    Computer type
    PC/Desktop
    Manufacturer/Model
    Home Built
    CPU
    AMD FX Black Edition
    Motherboard
    Asus M5A97 LE R2.0
    Memory
    16MB DDR
    Graphics card(s)
    I forget, but it's old.
    Sound Card
    Propietary
    Monitor(s) Displays
    ACER LED 24"
    Screen Resolution
    1920X1080
    Hard Drives
    1TB Samsung SSD 3.5"
    Case
    Corsair
    Cooling
    Stock
    Mouse
    Logitech
    Keyboard
    Logitech
    Internet Speed
    120MB/10MB
    Browser
    Chrome
    Antivirus
    Norton 360
    Other Info
    Currently taken down because of a lack of space :-(
    Maybe I'll make room somewhere and connect to the Dev channel if possible.

robgr

Active member
Thread Starter
Local time
12:07 PM
Posts
83
OS
Windows 11
I just tried to figure this out myself...... It appears that you now need to change the "Locale" in the format cells dialog box.
I was able to change to English (United Kingdom) and it offered me a whole different set of formatting options to use to format the cell.

View attachment 14150View attachment 14151
I am already on English (United Kingdom) locale. This is what I see
 

Attachments

  • excel format issue.jpg
    excel format issue.jpg
    51.1 KB · Views: 4

My Computer

System One

  • OS
    Windows 11
    Computer type
    PC/Desktop
    Manufacturer/Model
    PCSpecialist
    CPU
    Intel(R) Core(TM) i7-1070
    Motherboard
    TUF GAMING B460-PLUS
    Memory
    32 GBytes DDR4-2667 (1333 MHz)
    Graphics Card(s)
    NVIDIA GeForce GT 1030
    Sound Card
    ONBOARD 6 CHANNEL (5.1) HIGH DEF AUDIO (AS STANDARD)
    Monitor(s) Displays
    Samsung U32J590UQU
    Screen Resolution
    4k
    Hard Drives
    SYSTEM Win 10 237.22GB SSD Disk 0 238.47GB M2 (mobo)
    DATA Data 931.41GB HD 2.5" Disk 1 931.51GB SATA3
    BACKUPS Backups 2TB HD 3.5" Disk 2 2TB SATA3
    PSU
    CORSAIR 550W CV SERIES™ CV-550 POWER SUPPLY
    Case
    PCS 3601 CASE
    Cooling
    CoolerMaster Hyper 212 (120mm) Fan CPU Cooler Black Edition
    Internet Speed
    57/18 Mbps
    Browser
    Vivaldi
    Antivirus
    Kaspersky Total Security

Ghot

Well-known member
Pro User
VIP
Local time
7:07 AM
Posts
4,895
Location
PA, USA
OS
Win 11 Home ♦♦♦22621.900 ♦♦♦♦♦♦22H2
Month only goes up to 12
Day can go to 31
Year can go to infinity.

Which is why it should be mm/dd/yyyy
 

My Computers

System One System Two

  • OS
    Win 11 Home ♦♦♦22621.900 ♦♦♦♦♦♦22H2
    Computer type
    PC/Desktop
    Manufacturer/Model
    Built by Ghot® [May 2020]
    CPU
    AMD Ryzen 7 3700X
    Motherboard
    Asus Pro WS X570-ACE (BIOS 4201)
    Memory
    G.Skill (F4-3200C14D-16GTZKW)
    Graphics Card(s)
    EVGA RTX 2070 (08G-P4-2171-KR)
    Sound Card
    Realtek ALC1220P / ALC S1220A
    Monitor(s) Displays
    Dell U3011 30"
    Screen Resolution
    2560 x 1600
    Hard Drives
    2x Samsung 860 EVO 500GB,
    WD 4TB Black FZBX - SATA III,
    WD 8TB Black FZBX - SATA III,
    DRW-24B1ST CD/DVD Burner
    PSU
    PC Power & Cooling 750W Quad EPS12V
    Case
    Cooler Master ATCS 840 Tower
    Cooling
    CM Hyper 212 EVO (push/pull)
    Keyboard
    Ducky DK9008 Shine II Blue LED
    Mouse
    Logitech Optical M-100
    Internet Speed
    100/100
    Browser
    Firefox (latest)
    Antivirus
    Bitdefender Internet Security
    Other Info
    Speakers: Klipsch Pro Media 2.1
  • Operating System
    Windows XP Pro 32bit w/SP3
    Computer type
    PC/Desktop
    Manufacturer/Model
    Built by Ghot® (not in use)
    CPU
    AMD Athlon 64 X2 5000+ (OC'd @ 3.2Ghz)
    Motherboard
    ASUS M2N32-SLI Deluxe Wireless Edition
    Memory
    TWIN2X2048-6400C4DHX (2 x 1GB, DDR2 800)
    Graphics card(s)
    EVGA 256-P2-N758-TR GeForce 8600GT SSC
    Sound Card
    Onboard
    Monitor(s) Displays
    ViewSonic G90FB Black 19" Professional (CRT)
    Screen Resolution
    up to 2048 x 1536
    Hard Drives
    WD 36GB 10,000rpm Raptor SATA
    Seagate 80GB 7200rpm SATA
    Lite-On LTR-52246S CD/RW
    Lite-On LH-18A1P CD/DVD Burner
    PSU
    PC Power & Cooling Silencer 750 Quad EPS12V
    Case
    Generic Beige case, 80mm fans
    Cooling
    ZALMAN 9500A 92mm CPU Cooler
    Mouse
    Logitech Optical M-BT96a
    Keyboard
    Logitech Classic Keybooard 200
    Internet Speed
    100/100
    Browser
    Firefox 3.x ??
    Antivirus
    Symantec (Norton)
    Other Info
    Still assembled, still runs. Haven't turned it on for 13 years?

    http://www.xtremesystems.org/forums/showthread.php?183088-5000-B-E-on-M2N32-SLI-Dlx-Overclocked&p=2891724#post2891724

robgr

Active member
Thread Starter
Local time
12:07 PM
Posts
83
OS
Windows 11
Month only goes up to 12
Day can go to 31
Year can go to infinity.

Which is why it should be mm/dd/yyyy
Understood but I don't see any format types using a forward slash as a separator?
 

My Computer

System One

  • OS
    Windows 11
    Computer type
    PC/Desktop
    Manufacturer/Model
    PCSpecialist
    CPU
    Intel(R) Core(TM) i7-1070
    Motherboard
    TUF GAMING B460-PLUS
    Memory
    32 GBytes DDR4-2667 (1333 MHz)
    Graphics Card(s)
    NVIDIA GeForce GT 1030
    Sound Card
    ONBOARD 6 CHANNEL (5.1) HIGH DEF AUDIO (AS STANDARD)
    Monitor(s) Displays
    Samsung U32J590UQU
    Screen Resolution
    4k
    Hard Drives
    SYSTEM Win 10 237.22GB SSD Disk 0 238.47GB M2 (mobo)
    DATA Data 931.41GB HD 2.5" Disk 1 931.51GB SATA3
    BACKUPS Backups 2TB HD 3.5" Disk 2 2TB SATA3
    PSU
    CORSAIR 550W CV SERIES™ CV-550 POWER SUPPLY
    Case
    PCS 3601 CASE
    Cooling
    CoolerMaster Hyper 212 (120mm) Fan CPU Cooler Black Edition
    Internet Speed
    57/18 Mbps
    Browser
    Vivaldi
    Antivirus
    Kaspersky Total Security

Bree

Well-known member
Guru
VIP
Local time
12:07 PM
Posts
7,430
Location
S/E England, UK
OS
Windows 11 Home
Month only goes up to 12
Day can go to 31
Year can go to infinity.

Which is why it should be mm/dd/yyyy
For being able to sort by date in text or filenames it is best to use ISO 8601 date format: YYYY-MM-DD
It has the further advantage that it can be extended to include time of day yyy-mm-dd-hh-mm-ss
It can also include the timezone so there can be no confusion about the date.

Even Microsoft use ISO 8601 dates, ever looked at a File History folder?

1637421431617.png
 

My Computers

System One System Two

  • OS
    Windows 11 Home
    Computer type
    Laptop
    Manufacturer/Model
    Acer Aspire 3 A315-23
    CPU
    AMD Athlon Silver 3050U
    Memory
    8GB
    Graphics Card(s)
    Radeon Graphics
    Monitor(s) Displays
    laptop screen
    Screen Resolution
    1366x768 native resolution, up to 2560x1440 with Radeon Virtual Super Resolution
    Hard Drives
    1TB Samsung EVO 870 SSD
    Browser
    Edge, Firefox
    Antivirus
    Defender
    Other Info
    fully 'Windows 11 ready' laptop. Windows 10 C: partition migrated from my old unsupported 'main machine' then upgraded to 11. A test migration ran Insider builds for 2 months. When 11 was released on 5th October it was re-imaged back to 10 and was offered the upgrade in Windows Update on 20th October. Windows Update offered the 22H2 Feature Update on 20th September 2022.

    My SYSTEM THREE is a Dell Latitude 5410, i7-10610U, 32GB RAM, 512GB ssd, supported device running Windows 11 Pro.

    My SYSTEM FOUR is a 2-in-1 convertible Lenovo Yoga 11e 20DA, Celeron N2930, 4GB RAM, 128GB ssd. Unsupported device: currently running Win10 Pro, plus Win11 Pro 22H2 Insider Beta as a native boot vhdx.

    My SYSTEM FIVE is a Dell Latitude 3190 2-in-1, Pentium Silver N5030, 4GB RAM, 128GB NVMe ssd, supported device running Windows 11 Pro.
  • Operating System
    Windows 11 Pro
    Computer type
    Laptop
    Manufacturer/Model
    Dell Lattitude E4310
    CPU
    i5 M 520
    Motherboard
    0T6M8G
    Memory
    4GB
    Screen Resolution
    1366x768
    Hard Drives
    500GB HDD
    Browser
    Firefox, Edge
    Antivirus
    Defender
    Other Info
    unsupported machine: Legacy bios, MBR, TPM 1.2, upgraded from W10 to W11 using W10/W11 hybrid install media workaround. In-place upgrade to 22H2 using ISO and a workaround.

    My SYSTEM THREE is a Dell Latitude 5410, i7-10610U, 32GB RAM, 512GB ssd, supported device running Windows 11 Pro.

    My SYSTEM FOUR is a 2-in-1 convertible Lenovo Yoga 11e 20DA, Celeron N2930, 4GB RAM, 128GB ssd. Unsupported device: currently running Win10 Pro, plus Win11 Pro 22H2 Insider Beta as a native boot vhdx.

    My SYSTEM FIVE is a Dell Latitude 3190 2-in-1, Pentium Silver N5030, 4GB RAM, 128GB NVMe ssd, supported device running Windows 11 Pro.

robgr

Active member
Thread Starter
Local time
12:07 PM
Posts
83
OS
Windows 11
Just noticed it's the same for Outlook365 but Word365 appears unaffected for an inserted date (in that it appears as Sat, 20/11/2021)
 

Attachments

  • outlook date format.jpg
    outlook date format.jpg
    45.3 KB · Views: 3

My Computer

System One

  • OS
    Windows 11
    Computer type
    PC/Desktop
    Manufacturer/Model
    PCSpecialist
    CPU
    Intel(R) Core(TM) i7-1070
    Motherboard
    TUF GAMING B460-PLUS
    Memory
    32 GBytes DDR4-2667 (1333 MHz)
    Graphics Card(s)
    NVIDIA GeForce GT 1030
    Sound Card
    ONBOARD 6 CHANNEL (5.1) HIGH DEF AUDIO (AS STANDARD)
    Monitor(s) Displays
    Samsung U32J590UQU
    Screen Resolution
    4k
    Hard Drives
    SYSTEM Win 10 237.22GB SSD Disk 0 238.47GB M2 (mobo)
    DATA Data 931.41GB HD 2.5" Disk 1 931.51GB SATA3
    BACKUPS Backups 2TB HD 3.5" Disk 2 2TB SATA3
    PSU
    CORSAIR 550W CV SERIES™ CV-550 POWER SUPPLY
    Case
    PCS 3601 CASE
    Cooling
    CoolerMaster Hyper 212 (120mm) Fan CPU Cooler Black Edition
    Internet Speed
    57/18 Mbps
    Browser
    Vivaldi
    Antivirus
    Kaspersky Total Security

robgr

Active member
Thread Starter
Local time
12:07 PM
Posts
83
OS
Windows 11
Just realised that it was a recent change to the Region to show the day of the week in the Taskbar Clock that causes this issue
I followed the procedure here but it appears to cause unexpected behaviour for date format elsewhere
 

My Computer

System One

  • OS
    Windows 11
    Computer type
    PC/Desktop
    Manufacturer/Model
    PCSpecialist
    CPU
    Intel(R) Core(TM) i7-1070
    Motherboard
    TUF GAMING B460-PLUS
    Memory
    32 GBytes DDR4-2667 (1333 MHz)
    Graphics Card(s)
    NVIDIA GeForce GT 1030
    Sound Card
    ONBOARD 6 CHANNEL (5.1) HIGH DEF AUDIO (AS STANDARD)
    Monitor(s) Displays
    Samsung U32J590UQU
    Screen Resolution
    4k
    Hard Drives
    SYSTEM Win 10 237.22GB SSD Disk 0 238.47GB M2 (mobo)
    DATA Data 931.41GB HD 2.5" Disk 1 931.51GB SATA3
    BACKUPS Backups 2TB HD 3.5" Disk 2 2TB SATA3
    PSU
    CORSAIR 550W CV SERIES™ CV-550 POWER SUPPLY
    Case
    PCS 3601 CASE
    Cooling
    CoolerMaster Hyper 212 (120mm) Fan CPU Cooler Black Edition
    Internet Speed
    57/18 Mbps
    Browser
    Vivaldi
    Antivirus
    Kaspersky Total Security

rpetruzz

Active member
Local time
7:07 AM
Posts
6
OS
Windows 11 Pro X64 21H2
One other thought, in the format cells dialog there is an option for custom formats. Would this help??

1637433531919.png1637433574810.png
 

My Computers

System One System Two

  • OS
    Windows 11 Pro X64 21H2
    Computer type
    PC/Desktop
    Manufacturer/Model
    DIY Build
    CPU
    AMD Ryzen 7 3800X
    Motherboard
    ASUS ROG STRIX X570-E GAMING
    Memory
    Corsair DDR4-2132 4x16gb Dual Channel
    Graphics Card(s)
    NVIDIA GeForce RTX 3080TI
    Sound Card
    On motherboard
    Monitor(s) Displays
    2 - NEC PA241W
    Screen Resolution
    1920X1200
    Hard Drives
    1 - WD_BLACK 1TB SN850X NVMe Internal Gaming SSD Solid State Drive - Gen4 PCIe, M.2 2280
    1 - WD_BLACK 2TB SN850X NVMe Internal Gaming SSD Solid State Drive - Gen4 PCIe, M.2 2280
    PSU
    850 Watt Corsair® RM850x 80+
    Case
    Maingear ATX
    Cooling
    Wraith Prism cooler
    Keyboard
    Microsoft Sidewinder
    Mouse
    Logitech
    Internet Speed
    Spectrum - 300mbs
    Browser
    Chrome
    Antivirus
    Windows Defender
  • Operating System
    Windows 10 Pro X64 21H1
    Computer type
    Laptop
    Manufacturer/Model
    Maingear Element
    CPU
    Intel Core i7 9750H
    Motherboard
    Intel LAPQC71B
    Memory
    32gb - Kingston DDR4 1333 Mhz Dual channel
    Graphics card(s)
    NVIDIA GeForce RTX 2070 Max Q
    Sound Card
    On board
    Monitor(s) Displays
    LCD
    Screen Resolution
    1920x1080
    Hard Drives
    2tb INTEL SSD PEKNW020T8
    PSU
    On board
    Case
    Laptop
    Cooling
    Fans
    Mouse
    TeckNet
    Keyboard
    On Board
    Internet Speed
    Spectrum 200mbps
    Browser
    Chrome
    Antivirus
    Windows Defender

Zardoc

Dazed & Confused
Power User
VIP
Local time
7:07 AM
Posts
711
Location
In a van down by the river
OS
Windows 11 Enterprise
Hi,
Since I work in both French and English, I need to adjust this all the time.

The regional format can also affect the excel settings. This is my actual in French.
1641995604922.png

Just changed to English
1641995682064.png

Excel
1641995745291.png

Hope that helps. :wink:
 

My Computer

System One

  • OS
    Windows 11 Enterprise
    Computer type
    PC/Desktop
    CPU
    Intel® Core™ i7-12700K Processor 25M Cache, up to 5.00
    Motherboard
    Asus TUF Gaming Z690-PLUS WIFI D4
    Memory
    G.Skill Ripjaws V Series 32gb (2x16gb) DDR4 3200mhz
    Graphics Card(s)
    Asus Dual Geforce Rtx™ 2070 Oc Edition 8gb Gddr6
    Monitor(s) Displays
    BenQ EW3270U 31.5” 3840x2160 UHD 16:9 HDR LED 4K LG 27UK850-W 27'' 4K UHD IPS LED Monitor with HDR10
    Screen Resolution
    3840x2160
    Hard Drives
    Samsung 980 PRO PCIe 4.0 Gen 4 NVMe® SSD 1TB
    Samsung 980 PRO PCIe 4.0 Gen 4 NVMe® SSD 250GB
    Samsung 970 Evo M.2 2280 2tb Pcie Gen3. X4
    Crucial MX500 2TB 3D NAND SATA Internal SSD
    PSU
    Corsair AXi Series AX860i Digital 860W 80 PLUS PSU
    Case
    Corsair 275R ATX Mid Tower Case
    Keyboard
    Logi MX Keys
    Mouse
    Logi M705
    Internet Speed
    400 mbs
    Browser
    Firefox
    Antivirus
    Eset NOD32
    Other Info
    Love fast boots

jimbo45

Well-known member
Power User
VIP
Local time
12:07 PM
Posts
2,250
Location
Hafnarfjörður IS
OS
Windows XP,7,10,11 Linux Arch Linux
Month only goes up to 12
Day can go to 31
Year can go to infinity.

Which is why it should be mm/dd/yyyy
Hi there
Any type of sorting on that Bonkers USA date system is going to throw up all sorts of needless problems -- apart from mis-understanding possibilities with people on the rest of the planet. Even the US Military uses 24 hr clock based on GMT - I think they've tried to "Colonize it" by calling it UTC or by some other silly even more bonkers name.
Either yyyy/mm/dd or dd/mm/yyyy is easy to handle. Their system is totally crazy as is their temperature (Fahrenheit) based on a Polish guy who used random mixtures of salt and ice blocks in water from dubious sources to determine what the zero was -- and the poor souls can't even get those increasingly disused Imperial measurements right -- ever heard of a US gallon and Pint - and they probably still use "Rods, Poles and Perches" for measuring real estate specifications.

Cheers
jimbo
 

My Computer

System One

  • OS
    Windows XP,7,10,11 Linux Arch Linux
    Computer type
    PC/Desktop
    CPU
    2 X Intel i7

Zardoc

Dazed & Confused
Power User
VIP
Local time
7:07 AM
Posts
711
Location
In a van down by the river
OS
Windows 11 Enterprise
In Canada, the English mostly refer to time as let's say 8pm and the French will often use 20 h, which to me is less confusing as I get older. o_O
 

My Computer

System One

  • OS
    Windows 11 Enterprise
    Computer type
    PC/Desktop
    CPU
    Intel® Core™ i7-12700K Processor 25M Cache, up to 5.00
    Motherboard
    Asus TUF Gaming Z690-PLUS WIFI D4
    Memory
    G.Skill Ripjaws V Series 32gb (2x16gb) DDR4 3200mhz
    Graphics Card(s)
    Asus Dual Geforce Rtx™ 2070 Oc Edition 8gb Gddr6
    Monitor(s) Displays
    BenQ EW3270U 31.5” 3840x2160 UHD 16:9 HDR LED 4K LG 27UK850-W 27'' 4K UHD IPS LED Monitor with HDR10
    Screen Resolution
    3840x2160
    Hard Drives
    Samsung 980 PRO PCIe 4.0 Gen 4 NVMe® SSD 1TB
    Samsung 980 PRO PCIe 4.0 Gen 4 NVMe® SSD 250GB
    Samsung 970 Evo M.2 2280 2tb Pcie Gen3. X4
    Crucial MX500 2TB 3D NAND SATA Internal SSD
    PSU
    Corsair AXi Series AX860i Digital 860W 80 PLUS PSU
    Case
    Corsair 275R ATX Mid Tower Case
    Keyboard
    Logi MX Keys
    Mouse
    Logi M705
    Internet Speed
    400 mbs
    Browser
    Firefox
    Antivirus
    Eset NOD32
    Other Info
    Love fast boots

The-Hive

The First Three Star Guru
Guru
VIP
Local time
12:07 PM
Posts
11,343
Location
Wiltshire UK
OS
Windows 11 Pro
Month only goes up to 12
Day can go to 31
Year can go to infinity.

Which is why it should be mm/dd/yyyy
Unless you're in the UK :)
 

My Computers

System One System Two

  • OS
    Windows 11 Pro
    Computer type
    Laptop
    Manufacturer/Model
    Alienware Area 51m R2
    CPU
    10th Gen Core i9 10900K
    Memory
    32GB
    Graphics Card(s)
    Geforce RTX 2080 Super
    Sound Card
    Nvidia HD
    Screen Resolution
    1920x1080
    Hard Drives
    C: Samsung 2TB P981A
    D: Samsung 2TB 970 Evo
    Case
    Dark side of the moon
    Mouse
    Alienware AW610M
    Browser
    Chrome and Firefox
    Antivirus
    Norton
    Other Info
    Killer E3000 Ethernet Controller
    Killer AX1650i Wi-Fi Network Adaptor
    Alienware Z01G Graphic Amplifier
    Tobii Eye Tracker
  • Operating System
    Dual Boot Windows 11 Pro / Windows 11 Pro Dev build
    Computer type
    Laptop
    Manufacturer/Model
    Dell Inspiron 3501
    CPU
    11th Gen i-7 2.80 gb
    Memory
    16Gb
    Screen Resolution
    1920 x 1080
    Hard Drives
    512Gb SSD
    WD 2GB EXT
    Browser
    Chrome
    Antivirus
    Norton

Berton

Well-known member
Power User
VIP
Local time
5:07 AM
Posts
1,375
Location
Buffalo, Wyoming
OS
Win11 Pro RTM
An observation: the format in the US of mm/dd/yyyy 01/12/2022 is equivalent to the common hand-written display of January 12, 2022.
 

My Computers

System One System Two

  • OS
    Win11 Pro RTM
    Computer type
    Laptop
    Manufacturer/Model
    Dell Vostro 3400
    CPU
    Intel Core i5
    Memory
    8GB
    Hard Drives
    256GB SSD NVMe
  • Operating System
    Windows 11 Pro RTM x64
    Computer type
    PC/Desktop
    Manufacturer/Model
    Dell Vostro 5890
    CPU
    Intel Core i5
    Memory
    16GB
    Graphics card(s)
    Onboard, no VGA, using a DisplayPort-to-VGA adapter
    Monitor(s) Displays
    21"
    Hard Drives
    512GB SSD NVMe, 2TB WDC HDD
    Browser
    Firefox, Edge
    Antivirus
    Windows Defender/Microsoft Security

jimbo45

Well-known member
Power User
VIP
Local time
12:07 PM
Posts
2,250
Location
Hafnarfjörður IS
OS
Windows XP,7,10,11 Linux Arch Linux
An observation: the format in the US of mm/dd/yyyy 01/12/2022 is equivalent to the common hand-written display of January 12, 2022.
Try any type of sorting on that text -- February would come before January and April and August would be at the start of the sequence.

I'm not Anti US - US has saved a lot of people's bacon for far longer than most people especially younger ones ever realize in spite of current internal problems over there - but you can't defend the "Indefensible".

Cheers
jimbo
 

My Computer

System One

  • OS
    Windows XP,7,10,11 Linux Arch Linux
    Computer type
    PC/Desktop
    CPU
    2 X Intel i7

Slavic

Active member
Member
VIP
Local time
3:07 PM
Posts
215
OS
Windows 11 Pro; Windows 8.1 Pro
Any type of sorting on that Bonkers USA date system is going to throw up all sorts of needless problems -- apart from mis-understanding possibilities with people on the rest of the planet. Even the US Military uses 24 hr clock based on GMT - I think they've tried to "Colonize it" by calling it UTC or by some other silly even more bonkers name.
Either yyyy/mm/dd or dd/mm/yyyy is easy to handle. Their system is totally crazy as is their temperature (Fahrenheit) based on a Polish guy who used random mixtures of salt and ice blocks in water from dubious sources to determine what the zero was -- and the poor souls can't even get those increasingly disused Imperial measurements right -- ever heard of a US gallon and Pint - and they probably still use "Rods, Poles and Perches" for measuring real estate specifications.
:ROFLMAO:
For reference: Metrication in the United States
 

My Computer

System One

  • OS
    Windows 11 Pro; Windows 8.1 Pro
    Computer type
    PC/Desktop
    CPU
    i7-12700K (Alder Lake)
    Motherboard
    Asus PRIME Z690-M Plus D4
    Memory
    16 GB (2x8 Corsair DDR4-2132)
    Graphics Card(s)
    Asus GeForce 1050 Ti, 4 GB
    Monitor(s) Displays
    Philips 235PQ
    Screen Resolution
    1920x1080
    Hard Drives
    Windows 11: Samsung SSD 870 EVO, 500 GB (SATA), MBR
    Windows 8.1: Samsung SSD 980 PRO, 500 GB (M.2), MBR
    PSU
    Platimax D.F. 1050 W (80 Plus Platinum)
    Internet Speed
    Local link 1 Gbps, provider's line 500 Mbps
    Browser
    Google Chrome
    Other Info
    Realtek PCIe GbE Family Controller (for Windows 8.1 compatibility)
    Microsoft Office H&S 2013 x64

Superfly

Well-known member
Power User
VIP
Local time
2:07 PM
Posts
510
OS
Windows
Unless you're in the UK :)
Well not just the UK .. but still I don't get the logic there.

In the UK they still use Horsepower as opposed to Nm.. . so lets not throw stones...

As an aside - Dates have always been a problem for junior programmers - it's a lot easier now with .Net formatting but yep - it should be standardised to dd/MM/YYYY
 

My Computer

System One

  • OS
    Windows

The-Hive

The First Three Star Guru
Guru
VIP
Local time
12:07 PM
Posts
11,343
Location
Wiltshire UK
OS
Windows 11 Pro
I think it is smallest unit first D biggest last Y
Don't you use miles instead of kilometres? :ROFLMAO::ROFLMAO:
 

My Computers

System One System Two

  • OS
    Windows 11 Pro
    Computer type
    Laptop
    Manufacturer/Model
    Alienware Area 51m R2
    CPU
    10th Gen Core i9 10900K
    Memory
    32GB
    Graphics Card(s)
    Geforce RTX 2080 Super
    Sound Card
    Nvidia HD
    Screen Resolution
    1920x1080
    Hard Drives
    C: Samsung 2TB P981A
    D: Samsung 2TB 970 Evo
    Case
    Dark side of the moon
    Mouse
    Alienware AW610M
    Browser
    Chrome and Firefox
    Antivirus
    Norton
    Other Info
    Killer E3000 Ethernet Controller
    Killer AX1650i Wi-Fi Network Adaptor
    Alienware Z01G Graphic Amplifier
    Tobii Eye Tracker
  • Operating System
    Dual Boot Windows 11 Pro / Windows 11 Pro Dev build
    Computer type
    Laptop
    Manufacturer/Model
    Dell Inspiron 3501
    CPU
    11th Gen i-7 2.80 gb
    Memory
    16Gb
    Screen Resolution
    1920 x 1080
    Hard Drives
    512Gb SSD
    WD 2GB EXT
    Browser
    Chrome
    Antivirus
    Norton

Latest Support Threads

Top Bottom