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
Orbital Shark

 
 
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"..

Custom Date Settings...Inconcistencies-date-long.png

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
Custom Date Settings...Inconcistencies-format-cells-ddd.png

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

Custom Date Settings...Inconcistencies-date-short.png

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

Excel - Back to normal
Custom Date Settings...Inconcistencies-format-cells-without-ddd.png

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
kronckew

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
eMorgana

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
Thread Forum
Left 4 Dead 1 won't save my custom settings?
L4D1 won't save my custom settings? I try the steam cloud but its unselectable. Every time I close and start the game it always go back to its default settings which I don't like... So can you help me how fix this problem? But the game works fine for me. I'm playing l4d (non-steam).
Gaming
Custom Power Settings
I've searched the tutorials and the forum and couldn't find anything on the following: Is there a way set a schedule for sleep mode? I would like my system to go to sleep at 11:00PM and awaken at 6:45AM 7 days a week. If so, how is it done? TIA Randy
General Discussion
Where are custom toolbars settings stored ?
Is there a file or folder that contains the setup for any custom tool bars I am using ? Occasionally I seem to loose the setup I have for 1/2 dozen custom tool bars. What/where are these settings stored and if I get some errors or corruption in the displayed toolbars...can I get a restore from a...
Performance & Maintenance
Custom Mouse Settings
I am running a new Win7 64bit Ultimate system and trying to configure my MS Explorer Mouse's custom button settings. On my XP systems I would just drop the custom menu, search for that explore command and add the functions to make the button open in the root directory. I can't figure this one out...
Installation & Setup
Best way to reset win7 settings to an earlier date?
Ok I have not done an official backup of win7, although after I get this mess straightened out, I will be using Acronis. Now I seemed to really messed up trying to delete Adobe Reader & Acrobat and instead of using their uninstall programs, I used Windows Install Cleaner & well, it left some...
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 11:26.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App