Date Format 1

[Mighty]

I have a strange date format. My hard drive crashed and I have built XP back up using a new drive. I had a number of scheduled tasks that run using my username which send out email reports to users.

I have set the date format on my machine to dd-MMM-yy. However, any of the reports that are getting emailed from my machine all have dates in mm/dd/yyyy format.

Any suggestions why this is happening?

Mighty

 

[drbtodd1971]

Have you checked in Regional Settings off Control Panel (In Classic View)? The date format is in there in several different areas and usually defaults to American format.

Check on Regional Options tab in Short and Long Date. Check location is United Kingdom. Click customize button and check date formats in date tab.

Check languages tab that input is UK and that the keyboard is uk.

Check on advanced tab that Language is UK.

Hope this helps, I've had to do this loads of times on fresh XP installs.

 

[TheLad]

Agreed, mm/dd/yyyy is US format

--------------------------------------
"Insert funny comment in here!"
--------------------------------------

 

[Mighty]

Have already tried all the regional options. Keyboard is set to English (Ireland). Short date displays correctly in windows applications - just not right when I have scheduled reports sent out via email.

Mighty

 

[karlisi]

Perhaps reports are sent not under your account. Regional options are user dependent.

If you want to change date format for another user without logon as this user, open registry editor (regedit), load appropriate user hive (click to HKEY_USERS, then File->Load Hive, find target user's profile, click on 'ntuser.dat' then click Open, write in some key name to identify this key, click OK).
Then go to 'HKEY_USERS\key name you gave\Control Panel\International' and change key 'sShortDate' as you need. After that unload hive (click on 'HKEY_USERS\key name you gave', then File->Unload Hive, answer Yes) and close 'regedit'.

===
Karlis
ECDL; MCSA

 

[Mighty]

I will give that a try - but all reports run using my user account

Mighty

 

[linney]

Which E-mail program are you using? Does it make any difference if you test with another E-mail program?

I know you said Windows Applications are handling the Date correctly but have you checked the time and date in the Bios to see if that is correct?

Also have you tried changing the Date in Windows to see if it is (1) correct and (2) behaves differently if you change it to something else and then change it back, or just resubmit the Date again?

This is an example Command Prompt output.

C:\Users\xxxxxxxx>date
The current date is: Wed 06/08/2008
Enter the new date: (dd-mm-yy)

 

[Mighty]

I have IIS installed on my machine and the reports use the local SMTP server to route emails to my Exchange server. It is definitely using US Format as one of the reports that gets sent has a currency smybol and it had the dollar instead of the euro symbol.

However, all scheduled tasks are set to run with my user account so it's baffling me.

I also have an issue whereby I have about 10 automatic updates which have been downloaded but which won't install.

Could these issues be in any way related?

Mighty

 

[linney]

See if the fix here helps your Windows Update problem.

Windows Updates Fails After Upgrading to WindowsXP
thread779-1393612

 

[summer420]

In Regional Optional. Select “Customize”

In Customize Regional Options Dialog box Click DATE tab

 

[Mighty]

Date problem is sorted. Once I fixed the windows update issue, the date format issue also resolved itself!!

Mighty