Asked by:
Task notification emails have US date format in them?

Question
-
I have MOSS installed and everything works but I notice that the task
notification emails have US formatted dates in them - mm/dd/yyyy when
everything else is set to UK.I have set the regional settings on the site collection to UK. I have
set the regional settings in Windows Server to UK and cascaded down to
the default account and I am pretty sure that was done prior to the
MOSS install itself.All other dates in MOSS appear in UK format just fine.
Anyone any ideas as to how I can get UK formatted dates in the task
emails?Thanks.
Wednesday, January 17, 2007 9:17 AM
All replies
-
Hi Mark
I'm experiencing the same issue in my environment right now. Did you ever resolve this? At this stage, I suspect the regional settings on my outgoing mail server. I'll post back if I find an answer.
Ivan Wilson
Wednesday, April 4, 2007 8:42 AM -
Hey Ivan,
did you get to the bottom of this? I've just had the same questions! LOL
Nick
Friday, April 20, 2007 11:27 AM -
Has anyone managed to find a solution for this????? Its killing me!
thx.
Thursday, November 1, 2007 1:56 PM -
Hi Nugget, no luck yet. I'm waiting to see if this is fixed with Service Pack 1
Tuesday, November 6, 2007 11:10 AM -
Hi,
thx for the update.... Fingers crossed eh?.... or maybe wait until SP2? ;o)
Wednesday, November 14, 2007 10:31 AM -
Good to see that other people are having similar problems.
Did anyone get a fix for this, will be trying SP1 later today so let you know what happens.
Simon
Thursday, January 24, 2008 12:02 PM -
To solve this problem you need to change the "system locale". This is the locale used by applications running as a service, which includes OWSTimer.exe (which sends the alerts).
To do this run the "Regional and Language Options" Control Panel Applet, select the Advanced tab and change the "Language for non-unicode program" to "UK". You will need to restart the server and may need the Windows 2003 CD.
I've blogged this here: http://nickgrattan.wordpress.com/2008/01/24/date-format-incorrect-in-email-task-alerts/
Regards,
Nick Grattan.
Thursday, January 24, 2008 1:56 PM -
Hi Nick
I really appreciate you posting. We have the same problem here on a single server installation. Using your blog instructions I checked our setting using MSInfo which confirmed that locale was UK English. I checked it on the advanced tab on "Regional and Language Options", again it said it was UK.
As a long shot I tried setting it to USA English, rebooting the server, setting back to UK English and rebooting the server again. I'm afraid the problem still persists, most frustrating.
I'm pleased you have solved it at your site, I just thought I would post this in case other people out there had the same experience.
regards
Mike Hogan
Thursday, January 24, 2008 3:50 PM -
Mike,
Thanks for the feedback.
Did you change the regional settings to "English (UK)" for the site in which the task list is located?
Regards,
Nick Grattan.
Friday, January 25, 2008 1:37 PM -
Hi Nick
Yes everything is "English (UK)" with dates on the site itself formatting correctly.
regards,
Mike
Friday, January 25, 2008 1:58 PM -
Mike,
That's wierd. I went back and checked the logic and here are my results:
1. Fresh install of Windows 2003 Server, installed SharePoint 2007 without SP1.
2. Windows 2003 System locale is US (default), site regional settings US -> email has US format (expected).
3. Changed site regional settings to UK -> email has US format(wrong, but we know about that).
4. Changed Windows 2003 system locale to UK, site regional settings US - > email has US format
5. Changed site regional settings to UK -> email has UK format.
6. Changed Windows 2003 System locale to USA, site regional settings to UK -> email has UK format.
It seems that once the system locale has been set to UK once emails can be sent using the site regional settings regardless of the system locale. It seems that th UK locale files are somehow loaded onto the system.
Could it have something to do with the user under which OWSTimer runs? Which account do you use?
Regards,
Nick Grattan.
Friday, January 25, 2008 2:15 PM -
Not a workflow question so I'm moving the whole thread to the Admin forum.Sunday, January 27, 2008 8:59 AM
-
Hi Nick
I ran through the same sequence as you posted, with a server re-boot in between each combination and a test mail after every combination change with no luck.
I have tried a few more things - the Shared Services and Central Administration Site were still US English. I changed both of those. Again no luck.
Time is our enemy, so we will live with this for a while and maybe come back to it if the problem's perceived importance grows.Once again I am really grateful to you for taking the time to post replies.
regards,
Mike
Tuesday, January 29, 2008 3:49 PM -
I don't know if this makes any difference, but Nick's article on his blog is for Alert emails, and we're talking about Task notification emails - perhaps these are different in some way . . .
I've still not found any way to affect the formatting of the task notification US date format . . . .
Anyone else had any luck / spoken to MS about this ?
Monday, March 10, 2008 3:49 PM -
We're also experiencing this issue. Has MS released a fix yet?Tuesday, July 8, 2008 1:38 PM
-
Just in case anyone else followed this thread, this was fixed back in October 2008 Cumulative Update.
Description of the Windows SharePoint Services 3.0 hotfix package (Sts.msp): October 28, 2008
Regards
Simon
iThink SharePoint (http://ithinksharepoint.blogspot.com)Friday, October 9, 2009 10:57 AM