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


robgr

Well-known member
Local time
10:25 AM
Posts
89
Visit site
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
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 - always current.
    Computer type
    PC/Desktop
    Manufacturer/Model
    DIY Build
    CPU
    AMD Ryzen 9 3950X
    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
    Corsair 7000D AirFlow
    Cooling
    Corsair iCUE H150i Elite CAPELLIX XT Liquid CPU Cooler
    Keyboard
    Microsoft Sidewinder
    Mouse
    Logitech
    Internet Speed
    Spectrum - 300mbs
    Browser
    Chrome
    Antivirus
    Windows Defender
  • Operating System
    Windows 10 Pro X64 - always current
    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 300mbps
    Browser
    Chrome
    Antivirus
    Windows Defender
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 24H2 RP channel
    Computer type
    PC/Desktop
    Manufacturer/Model
    Home built
    CPU
    Ryzen 9 5900X
    Motherboard
    MSI MPG X570S Edge Max WiFi
    Memory
    Corsair Vengeance RGB PRO 64GB (2x32GB) DDR4 3600 (PC4-28800) C18
    Graphics Card(s)
    ASUS GeForce RTX 4070 Super OC 12GB DDR6 / ZOTAC RTX 3060 Twin Edge OC 12GB GDDR6
    Sound Card
    Proprietary on MB / FiiO K5Pro DAC
    Monitor(s) Displays
    ViewSonic XG2530 25"/Benq XL2411P 24"/ ASUS VA24DQSB) 23.8"
    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
    Corsair RM1000e
    Case
    Phanteks Enthoo Pro Full Tower Chassis with Window
    Cooling
    Corsair iCUE H60i RGB PRO XT Liquid CPU Cooler
    Keyboard
    Corsair K70
    Mouse
    Logitech MX Master 3
    Internet Speed
    ~950Mb/s download / ~700Mb/s upload
    Browser
    Edge (Chromium)
    Antivirus
    Norton 360
  • Operating System
    Windows 11 Pro
    Computer type
    PC/Desktop
    Manufacturer/Model
    Home Built
    CPU
    Ryzen 7 3700X
    Motherboard
    MSI B550 Gaming GEN3 Gaming Motherboard
    Memory
    32MB DDR4
    Graphics card(s)
    I forget, but it's old. I can't see the need to upgrade it.
    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
    ~750Mb/s download / ~750Mb/s upload
    Browser
    Edge
    Antivirus
    Defender and Malware Bytes
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
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 ♦♦♦26100.2605 ♦♦♦♦♦♦♦24H2 ♦♦♦non-Insider
    Computer type
    PC/Desktop
    Manufacturer/Model
    Built by Ghot® [May 2020]
    CPU
    AMD Ryzen 7 3700X
    Motherboard
    Asus Pro WS X570-ACE (BIOS 4702)
    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
    300/300
    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
    300/300
    Browser
    Firefox 3.x ??
    Antivirus
    Symantec (Norton)
    Other Info
    Still assembled, still runs. Haven't turned it on for 13 years?
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
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
    Internet Speed
    50 Mbps
    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 2021 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. It got the 23H2 Feature Update on 4th November 2023 through Windows Update, and 24H2 on 3rd October through Windows Update by setting the Target Release Version for 24H2.

    My SYSTEM THREE is a Dell Latitude 5410, i7-10610U, 32GB RAM, 512GB NVMe ssd, supported device running Windows 11 Pro (and all my Hyper-V VMs).

    My SYSTEM FOUR is a 2-in-1 convertible Lenovo Yoga 11e 20DA, Celeron N2930, 8GB RAM, 256GB ssd. Unsupported device: currently running Win10 Pro, plus Win11 Pro RTM and Insider Dev, Beta, and RP 24H2 as native boot vhdx.

    My SYSTEM FIVE is a Dell Latitude 3190 2-in-1, Pentium Silver N5030, 8GB RAM, 512GB NVMe ssd, supported device running Windows 11 Pro, plus the Insider Beta, Dev, Canary, and Release Preview builds as a native boot .vhdx.
  • Operating System
    Windows 11 Pro
    Computer type
    Laptop
    Manufacturer/Model
    Dell Latitude E4310
    CPU
    Intel® Core™ i5-520M
    Motherboard
    0T6M8G
    Memory
    8GB
    Graphics card(s)
    (integrated graphics) Intel HD Graphics
    Screen Resolution
    1366x768
    Hard Drives
    500GB Crucial MX500 SSD
    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. Feature Update to 23H2 by manually installing the Enablement Package. In-place upgrade to 24H2 using hybrid 23H2/24H2 install media. Also running Insider Beta, Dev, and Canary builds as a native boot .vhdx.

    My SYSTEM THREE is a Dell Latitude 5410, i7-10610U, 32GB RAM, 512GB NVMe ssd, supported device running Windows 11 Pro (and all my Hyper-V VMs).

    My SYSTEM FOUR is a 2-in-1 convertible Lenovo Yoga 11e 20DA, Celeron N2930, 8GB RAM, 256GB ssd. Unsupported device: currently running Win10 Pro, plus Win11 Pro RTM and Insider Dev, Beta, and RP 24H2 as native boot vhdx.

    My SYSTEM FIVE is a Dell Latitude 3190 2-in-1, Pentium Silver N5030, 8GB RAM, 512GB NVMe ssd, supported device running Windows 11 Pro, plus the Insider Beta, Dev, Canary, and Release Preview builds as a native boot .vhdx.
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
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
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 - always current.
    Computer type
    PC/Desktop
    Manufacturer/Model
    DIY Build
    CPU
    AMD Ryzen 9 3950X
    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
    Corsair 7000D AirFlow
    Cooling
    Corsair iCUE H150i Elite CAPELLIX XT Liquid CPU Cooler
    Keyboard
    Microsoft Sidewinder
    Mouse
    Logitech
    Internet Speed
    Spectrum - 300mbs
    Browser
    Chrome
    Antivirus
    Windows Defender
  • Operating System
    Windows 10 Pro X64 - always current
    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 300mbps
    Browser
    Chrome
    Antivirus
    Windows Defender
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. ;)
 

My Computer

System One

  • OS
    Windows 11 Pro
    Computer type
    PC/Desktop
    CPU
    Intel® Core™ i9-12900K Desktop Processor 16 (8P+8E)
    Motherboard
    Asus TUF Gaming Z790-PLUS WIFI D4
    Memory
    G.Skill Ripjaws V Series 32gb (2x16gb) DDR4 3200mhz
    Graphics Card(s)
    Asus Dual Geforce Rtx™ 3060 TI 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 990 with heatsink PRO PCIe 4.0 Gen 4 NVMe® SSD 1TB
    WD_BLACK SN850X NVMe M.2 2280 1TB PCI-Express 4.0
    Crucial T500 2TB Gen4
    Samsung 970 Evo M.2 2280 2tb Pcie Gen3. X4
    PSU
    Corsair AXi Series AX860i Digital 860W 80 PLUS PSU
    Case
    Fractal Meshify C 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
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
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 Pro
    Computer type
    PC/Desktop
    CPU
    Intel® Core™ i9-12900K Desktop Processor 16 (8P+8E)
    Motherboard
    Asus TUF Gaming Z790-PLUS WIFI D4
    Memory
    G.Skill Ripjaws V Series 32gb (2x16gb) DDR4 3200mhz
    Graphics Card(s)
    Asus Dual Geforce Rtx™ 3060 TI 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 990 with heatsink PRO PCIe 4.0 Gen 4 NVMe® SSD 1TB
    WD_BLACK SN850X NVMe M.2 2280 1TB PCI-Express 4.0
    Crucial T500 2TB Gen4
    Samsung 970 Evo M.2 2280 2tb Pcie Gen3. X4
    PSU
    Corsair AXi Series AX860i Digital 860W 80 PLUS PSU
    Case
    Fractal Meshify C 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
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 M18 R1
    CPU
    13th Gen Core i9 13900HX
    Memory
    32GB DDR5 @4800MHz 2x16GB
    Graphics Card(s)
    Geforce RTX 4090HX 16GB
    Sound Card
    Nvidia HD / Realtek ALC3254
    Monitor(s) Displays
    18" QHD+
    Screen Resolution
    25660 X 1600
    Hard Drives
    C: KIOXIA (Toshiba) 2TB KXG80ZNV2T04 NVMe PCIe M.2 SSD
    D: KIOXIA (Toshiba) 2TB KXG80ZNV2T04 NVMe PCIe M.2 SSD
    Case
    Dark Metallic Moon
    Keyboard
    Alienware M Series per-key AlienFX RGB
    Mouse
    Alienware AW610M
    Browser
    Chrome and Firefox
    Antivirus
    Norton
    Other Info
    Killer E3000 Ethernet Controller
    Killer Killer AX1690 Wi-Fi Network Adaptor Wi-Fi 6E
    Bluetooth 5.2
    Alienware Z01G Graphic Amplifier
  • Operating System
    Windows 11 Pro
    Computer type
    Laptop
    Manufacturer/Model
    Alienware Area 51m R2
    CPU
    10th Gen i-9 10900 K
    Memory
    32Gb Dual Channel DDR4 @ 8843MHz
    Graphics card(s)
    Nvidia RTX 2080 Super
    Sound Card
    Nvidia
    Screen Resolution
    1920 x 1080
    Hard Drives
    Hard Drive C: Samsung 2TB SSD PM981a NVMe
    Hard Drive D:Samsung 2TB SSD 970 EVO Plus
    Mouse
    Alienware 610M
    Browser
    Chrome
    Antivirus
    Norton
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 11th Gen. 2.40GHz
    Memory
    12GB
    Hard Drives
    256GB SSD NVMe M.2
  • Operating System
    Windows 11 Pro RTM x64
    Computer type
    PC/Desktop
    Manufacturer/Model
    Dell Vostro 5890
    CPU
    Intel Core i5 10th Gen. 2.90GHz
    Memory
    16GB
    Graphics card(s)
    Onboard, no VGA, using a DisplayPort-to-VGA adapter
    Monitor(s) Displays
    24" Dell
    Hard Drives
    512GB SSD NVMe, 4TB Seagate HDD
    Browser
    Firefox, Edge
    Antivirus
    Windows Defender/Microsoft Security
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
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
    Computer type
    Laptop
    Manufacturer/Model
    Lenovo Legion 5-15ARH05
    CPU
    AMD Rysen 5 4600H
    Memory
    32 GB
    Graphics Card(s)
    GeForce GTX 1650 Ti
    Screen Resolution
    1920x1080
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
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 M18 R1
    CPU
    13th Gen Core i9 13900HX
    Memory
    32GB DDR5 @4800MHz 2x16GB
    Graphics Card(s)
    Geforce RTX 4090HX 16GB
    Sound Card
    Nvidia HD / Realtek ALC3254
    Monitor(s) Displays
    18" QHD+
    Screen Resolution
    25660 X 1600
    Hard Drives
    C: KIOXIA (Toshiba) 2TB KXG80ZNV2T04 NVMe PCIe M.2 SSD
    D: KIOXIA (Toshiba) 2TB KXG80ZNV2T04 NVMe PCIe M.2 SSD
    Case
    Dark Metallic Moon
    Keyboard
    Alienware M Series per-key AlienFX RGB
    Mouse
    Alienware AW610M
    Browser
    Chrome and Firefox
    Antivirus
    Norton
    Other Info
    Killer E3000 Ethernet Controller
    Killer Killer AX1690 Wi-Fi Network Adaptor Wi-Fi 6E
    Bluetooth 5.2
    Alienware Z01G Graphic Amplifier
  • Operating System
    Windows 11 Pro
    Computer type
    Laptop
    Manufacturer/Model
    Alienware Area 51m R2
    CPU
    10th Gen i-9 10900 K
    Memory
    32Gb Dual Channel DDR4 @ 8843MHz
    Graphics card(s)
    Nvidia RTX 2080 Super
    Sound Card
    Nvidia
    Screen Resolution
    1920 x 1080
    Hard Drives
    Hard Drive C: Samsung 2TB SSD PM981a NVMe
    Hard Drive D:Samsung 2TB SSD 970 EVO Plus
    Mouse
    Alienware 610M
    Browser
    Chrome
    Antivirus
    Norton
Back
Top Bottom