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: Date format using space as date separator rather than forward slash!

07 Nov 2010   #11
Orbital Shark

 
 

Can you post a snip of the following please?

Control Panel -> Clock, Language, and Region -> Region and Language

Under the formats tab click 'Additional Settings...' (post that snip)

Date format using space as date separator rather than forward slash!-capture.png




My System SpecsSystem Spec
.
07 Nov 2010   #12
CiaraJansonFan

Windows 7 Home Premium 32-bit
 
 

Here you go:


Attached Images
Date format using space as date separator rather than forward slash!-date-format.jpg 
My System SpecsSystem Spec
07 Nov 2010   #13
Orbital Shark

 
 

I notice that you have "ddd" in front of the date format ("ddd dd/mm/yyy"). Try removing that as it could be what's conflicting.
My System SpecsSystem Spec
.

07 Nov 2010   #14
Orbital Shark

 
 

Ok, i've isolated that it is indeed the "ddd" that's causing the issue as i've just tried it and all date formats in Excel (even 2010) now have spaces seperating them...

With "ddd"
Date format using space as date separator rather than forward slash!-format-cells-ddd.png

Without "ddd"
Date format using space as date separator rather than forward slash!-format-cells-without-ddd.png


My System SpecsSystem Spec
07 Nov 2010   #15
CiaraJansonFan

Windows 7 Home Premium 32-bit
 
 

Yeah, you're right - but that's ridiculous! Why can't I show the day AND have slashes separating the day, month and year? That's the way I had XP set up

I want to see the DAY in my notification area, and in Task Scheduler, not have to look at a calendar to find out what day 02/11/2010 was!

How do I go about reporting this bug to Microsoft?!!?

Cheers
Steven
My System SpecsSystem Spec
07 Nov 2010   #16
Orbital Shark

 
 

It's a very strange fault (for want of a better word) so I've highlighted my findings in a new thread in the hope that someone may have found a way to work around it.

Custom Date Settings...Inconcistencies
My System SpecsSystem Spec
07 Nov 2010   #17
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.

in excel 2007, using ddd dd/mm/yyyy system setting, i could force cell formatting to the desired one by using the custom format of ddd dd/mm/yyyy, even if the date format was invalid.

my task scheduler dates show as Mon 08/11/201 as the string doesn't fit the space by one char. using the short year would fix that, ie. Mon 08/11/10.

to avoid ambiguity i always set my date string to military format dd mmm yyyy , giving 08 Nov 2010 which is unambiguous between the UK and my friends & relatives in the US.
My System SpecsSystem Spec
07 Nov 2010   #18
CiaraJansonFan

Windows 7 Home Premium 32-bit
 
 

It just has to be a bug in Windows 7 doesn't it?!!?

I mean if I select a custom date format of ddd dd/MM/yyyy, I do NOT want the slashes to be replaced with spaces, if I did I would have chosen ddd dd MM yyyy wouldn't I?!!? In fact, changing between those 2 date formats has absolutely NO effect on the dates shown in Task Scheduler, which it should do of course

Get it fixed Microsoft!!!

Steven
My System SpecsSystem Spec
08 Nov 2010   #19
CiaraJansonFan

Windows 7 Home Premium 32-bit
 
 

I was convinced that I had XP set up to show the day as well as the date, but it turns out I was mistaken and that you can reproduce this bug in Windows XP too - that makes it even worse!!
My System SpecsSystem Spec
18 Jan 2012   #20
bigmantonyd

Windows 7 Pro SP1 32bit
 
 

I ran into the same problem and I'm very thankful to have found this thread. As a workaround, I changed my short date format to MM/dd ddd. It's not ideal, but it fixes the problem and displays the same information (albeit in an unorthodox order). Thanks!
My System SpecsSystem Spec
Reply

 Date format using space as date separator rather than forward slash!




Thread Tools




Similar help and support threads
Thread Forum
Date Format - Change
How to Change Date Format in Windows 7 This tutorial will show you how to change the region date format to how you want it to display in Windows 7. Here's How: 1. Open the Control Panel (icons view), and click/tap on the Regional and Language Options icon, then close the Control Panel.
Tutorials
File search (by date range) displays incorrect Mod Date in results
Searching for files modified in a specified date range (of the past 3 days) gets a search result list titled "date modified", and with the column heading "Date Modified" but the date listed against a file modified today is wrong. The date displayed matches the file creation date & is within the...
General Discussion
How to change date separator
How could I set Regional settings formats to UK and change date separator from slash to point? (23.03.2011) Windows XP had Customize Regional options to change Date separator but it's missing on W7. Thanks!
General Discussion
Forward - Backward Slash?
If I type in or copy a file location in W7 (using back slashes) then try to paste it into a box in another application I get forward slashes and the application, whatever it is, cannot find that location. Eg. I type Z:\Graphics\Animals\Birds II\Lunch I get Z:/Graphics/Animals/Birds...
General Discussion
UK date format in Windows 7 RC
I live in the UK and want to use the day-month-year format in displaying the date. In Control Panel, Region and Language, Additional Settings, I've changed my Location and Keyboard, and set my date format to 'd.MMM.yy' (short) and 'dd MMMM yyyy' (long). In the W7 betas, this gave me a...
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 06:56.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App