Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Custom Date Settings...Inconcistencies


07 Nov 2010   #1

 
 
Custom Date Settings...Inconcistencies

This thread has led me to do some preliminary research into how Windows uses the 'Date' formats available.

Tip   Tip
To access custom date formats go to Control Panel -> Clock, Language, and Region -> Region and Language and click 'Additional Settings...'


Using 'Custom' date formats seems to result in an abnormality with the way applications read the current system date. I've included a couple of examples below...

1 prime example is if you wish to have a more detailed Date on the taskbar which included the day you'd set the following custom date format "ddd dd/mm/yyyy"..

Name:  Date - Long.PNG
Views: 12
Size:  68.8 KB

However...The space between the "ddd" and "dd" causes the following abnormalities.

Task Scheduler - Notice the date now has spaces instead of "/"
Custom Date Settings...Inconcistencies-task-sched-long-date.png

Same happens in Excel when formatting cells
Name:  Format Cells - With ddd.PNG
Views: 9
Size:  50.0 KB

I also changed them back so as to demonstrate how the default settings work perfectly well.

Name:  Date - Short.PNG
Views: 7
Size:  68.7 KB

Task Scheduler - Back to normal
Custom Date Settings...Inconcistencies-task-sched-short-date.png

Excel - Back to normal
Name:  Format Cells - Without ddd.PNG
Views: 2
Size:  37.8 KB

So as a warning to all who like to use 'Custom' date formats, please be aware that it will alter the way Windows & other apps read the current system date depending on what you've changed & how.


OS



My System SpecsSystem Spec
.

07 Nov 2010   #2

Win 7 ultimate x64 sp1
 
 

i've found the system format uses whatever the char. is after the initial ddd as the seperator, if you use

ddd dd/mm/yyyy you get Mon 08 11 2010
ddd, dd/mm/yyyy you get Mon, 08,11,2010

dddd dd/mm/yyyy similarly gives Monday 08 11 2010
dddd, dd/mm/yyyy gives Monday, 08,11,2010

unfortunately ddd/ .... gives Mon/ 08/11/2010.

this messes up the cell formatting, etc in MS office (excel). using a custom format of 'ddd dd/mm/yyyy' rather than a date format works however.
My System SpecsSystem Spec
14 Aug 2011   #3

windows 7
 
 

Just wondering whether a solution has been found for this problem???

I know I'm a bit late to the discussion, but I only got round to searching for a solution today. This has been driving me nuts for ages!!

As I'm a shift worker, working all hours of the day or night, I frequently find myself in the predicament of knowing the DATE (coz I see it hundreds of times in the course of my shift)... but not the DAY. Hence I want the DAY displayed in the taskbar.

However, my Excel then loses its slashes.

I've tried adding a 'custom' date setting to Excel to get the slashes back, and it works for that instance. However, next time you open the worksheet, the dates are back to space separators, and the 'custom' setting is gone!! So I have to redo everything each time I open an Excel spreadsheet.
My System SpecsSystem Spec
.


Reply

 Custom Date Settings...Inconcistencies




Thread Tools



Similar help and support threads for2: Custom Date Settings...Inconcistencies
Thread Forum
Left 4 Dead 1 won't save my custom settings? Gaming
Custom Power Settings General Discussion
Where are custom toolbars settings stored ? Performance & Maintenance
Epson Workforce 500 time and date settings Hardware & Devices
Custom Mouse Settings Installation & Setup
Best way to reset win7 settings to an earlier date? General Discussion

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 03:14 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33