Re: Server Performance Report - Date Format

On 5 Apr, 08:55, v-rob...@xxxxxxxxxxxxxxxxxxxx (Robert Li [MSFT])
wrote:
Hi Danil,

Thanks for posting in our newsgroup.

From your description, I know that 3 of the SBS Servers the date of
standard UK format. However the report from the Server4 has dates in a USA
format. If I am off-base, please don't hesitate to let me know.

If you want to change the Performance Report format on Server 4 to Standard
UK format, please do the following.

To resolve the problem we first put everything back to default English (UK):

1. Go to Control Panel\Regional and Language Options.

On the Regional Options Tab:
- Set "Standards and formats" to English (United Kingdom)
- Set "Location" to English (United Kingdom)

On the Advanced Tab:
- Set "Language for non-Unicode programs" to English (United
Kingdom)
- CHECK "Default user account settings"

2. Hit OK

3. Open Regedit and make sure the following sShortDate registry key is set
to m/d/yyyy:

HKEY_CURRENT_USER\Control Panel\International
HKEY_USERS\.DEFAULT\Control Panel\International
HKEY_USERS\S-1-5-18\Control Panel\International
HKEY_USERS\S-1-5-19\Control Panel\International
HKEY_USERS\S-1-5-20\Control Panel\International

4. Then perform an IISReset and log off/on.

Then to make sure the generated reports were viewed with the proper date
format we performed the following steps:

1. Go to Control Panel\Regional and Language Options.

On the Regional Options Tab:
- Set "Standards and formats" to English (United Kingdom)
- Set "Location" to English (United Kingdom)

On the Advanced Tab:
- Set "Language for non-Unicode programs" to English (United
Kingdom)
- DO NOT CHECK "Default user account settings"

2. Hit OK. Log off\on.

3. Open up regedit and set the following registry key:

HKEY_USERS\S-1-5-20\Control Panel\International
Value Name: sShortDate
Value Data: d/M/yyyy

4. Perform an IISReset then Log off\on.

5. Please create a new report to see if the problem will be resolved.

Hope above information helps

If you need further assistance, please don't hesitate to let me know.

Best regards,

Robert Li(MSFT)

Microsoft CSS Online Newsgroup Support

Get Secure! -www.microsoft.com/security

=====================================================

This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.

Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.

For urgent issues, you may want to contact Microsoft CSS directly. Please
checkhttp://support.microsoft.comfor regional support phone numbers.

Any input or comments in this thread are highly appreciated.

=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
<From: "Geoff Davis" <usenetgro...@xxxxxxxxxxx>
<Newsgroups: microsoft.public.windows.server.sbs
<Subject: Re: Server Performance Report - Date Format
<Date: 4 Apr 2007 07:26:45 -0700
<Organization:http://groups.google.com
<Lines: 21
<Message-ID: <1175696805.439820.75...@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>
<References: <1175694317.669151.45...@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>
<NNTP-Posting-Host: 212.57.242.37
<Mime-Version: 1.0
<Content-Type: text/plain; charset="iso-8859-1"
<X-Trace: posting.google.com 1175696808 20525 127.0.0.1 (4 Apr 2007
14:26:48 GMT)
<X-Complaints-To: groups-ab...@xxxxxxxxxx
<NNTP-Posting-Date: Wed, 4 Apr 2007 14:26:48 +0000 (UTC)
<In-Reply-To: <1175694317.669151.45...@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>
<User-Agent: G2/1.0
<X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT
5.1),gzip(gfe),gzip(gfe)
<Complaints-To: groups-ab...@xxxxxxxxxx
<Injection-Info: q75g2000hsh.googlegroups.com; posting-host=212.57.242.37;
< posting-account=ytjyhg0AAAAAwN8BYiS_gtMwDX88l1J9
<Path:
TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS02.phx.gbl!news-out­.
cwix.com!newsfeed.cwix.com!newscon02.news.prodigy.net!prodigy.net!border1..n­n
tp.dca.giganews.com!nntp.giganews.com!postnews.google.com!q75g2000hsh.googl­e
groups.com!not-for-mail
<Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.windows.server.sbs:27717
<X-Tomcat-NG: microsoft.public.windows.server.sbs
<
<On 4 Apr, 14:45, usenetgro...@xxxxxxxxxxx wrote:
<> I receive Emailed Server Performance Reports from 4 Servers (different
<> sites, not related). For 3 of the Servers the date format is in
<> standard UK format as set in the regional settings i.e. dd/mm/yyyy
<> hh:nn. eg for 3rd march 2007, "Report created on 03/04/2007 at 06:00"
<> However the report from the other Server (call it Server4) has dates
<> in a USA format and time in 12 hour format e.g. "Report created on
<> 4/3/2007 at 6:00 AM".
<>
<> I have checked and compared the regional settings on Server4 with the
<> other Servers and they are exactly the same. From the advanced
<> settings in the Regional Settings I have re-applied the settings to
<> the current account and the default account but this has made no
<> difference.
<>
<> I suspect that there is another setting somewhere that needs tweaking,
<> can anyone help please.
<
<Spot the deliberate mistake? Text should read "e.g. for 3rd April
<2007"
<
<

Robert

Can I clarify your instructions please. In Step 1 you say set the
regional settings to United Kingdom but in Step 3 you say check the
various Registry settings are set to m/d/yyyy which is USA format. So
do you mean set the settings to USA or should step 3 check for dd/mm/
yyyy?

Before making any changes I have checked the registry entries and

HKEY_CURRENT_USER\Control Panel\International = dd/MM/
yyyy
HKEY_USERS\.DEFAULT\Control Panel\International = dd/MM/
yyyy
HKEY_USERS\S-1-5-18\Control Panel\International = dd/MMM/
yyyy
HKEY_USERS\S-1-5-19\Control Panel\International = M/d/yyyy
HKEY_USERS\S-1-5-20\Control Panel\International = M/d/yyyy

So it would seem that the last two entries are having an effect on the
Date settings.

Regards

Geoff Davis



.

Relevant Pages

  • Re: Server Performance Report - Date Format
    ... standard UK format. ... However the report from the Server4 has dates in a USA ... If you want to change the Performance Report format on Server 4 to Standard ... DO NOT CHECK "Default user account settings" ...
    (microsoft.public.windows.server.sbs)
  • Re: dd/mm/yy format on textbox
    ... Mark, I'm not keen on that solution, as you are not interpreting the value the user typed according to their regional settings. ... I removed the format on the textboxes and set an input mask to force a date format. ... I set up a report dialog box as Shortdate for the date textboxes but the report wants mm/dd/yy format or it will display all of the results on the report. ...
    (microsoft.public.access.forms)
  • Force New Page Without Group Header
    ... report, as the majority of records do not belong to a case (and are therefore ... can fit onto the page where the case begins, I want the format to remain ... detail section resolves many other formatting issues that I have worked out. ... Tinkering with these settings has not produced the results I need. ...
    (microsoft.public.access.reports)
  • Server Performance Report - Date Format
    ... I receive Emailed Server Performance Reports from 4 Servers (different ... standard UK format as set in the regional settings i.e. dd/mm/yyyy ... However the report from the other Server has dates ... I have checked and compared the regional settings on Server4 with the ...
    (microsoft.public.windows.server.sbs)
  • Re: Local Group Policy versus OU (Time Service)
    ... One way I'd skin this is, if those servers are all over your domain (i.e. ... I very rarely come across a lot of differences in policy btw the PDC role ... because they'll all have identical settings. ... > lot of Group Policy settings differently on your DC's and member servers ...
    (microsoft.public.windows.group_policy)