Re: Data Format on SharePoint pages - how to set

{\rtf1\ansi\ansicpg936\deff0\deflang1033\deflangfe2052{\fonttbl{\f0\fnil\fprq2\fcharset0 MS Sans Serif;}}
\viewkind4\uc1\pard\lang2052\f0\fs20 Hi Bruce,
\par
\par Sorry for the typo mistake.
\par
\par Yes, for the regional setting, it cannot control detailed date format(like the operating system's date/time setting does). The reason why the operating system's regional setting doesn't control the WSS's date format(when the two setting matches) is that sharepoint use .NET framework Culture/formatting info which is separated from windows operating system.
\par
\par So far, for customzing the date display format in list column, there are some solution that use a calculated column to display the customized date format. Here is a web thread mentioned this:
\par
\par #Change Date Format of Site Column
\par http://www.sharepointu.com/forums/p/974/2849.aspx#2849
\par
\par Sincerely,
\par
\par Steven Cheng
\par
\par Microsoft MSDN Online Support Lead
\par
\par
\par Delighting our customers is our #1 priority. We welcome your comments and suggestions about how we can improve the support we provide to you. Please feel free to let my manager know what you think of the level of service provided. You can send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
\par
\par ==================================================
\par Get notification to my posts through email? Please refer to http://msdn.microsoft.com/en-us/subscriptions/aa948868.aspx#notifications.
\par
\par
\par
\par \pard\li720 --------------------
\par From: "Bruce Sanderson" <bsanders@xxxxxxxxxxxxxxxx>
\par In-Reply-To: <tKP$8wfTJHA.6048@xxxxxxxxxxxxxxxxxxxxxx>
\par Subject: Re: Data Format on SharePoint pages - how to set
\par Date: Tue, 25 Nov 2008 17:16:01 -0800
\par
\par
\par My name is Bruce, not Brian.
\par
\par There is no setting on either the site or personal SharePoint Regional
\par Settings for specifically setting the date format, just the "locale".
\par
\par As I stated in my original post, I've set the Regional Settings for the site
\par to English (Canada) locale. On all servers and client computers, the
\par Control Panel, Regional and Language Options are set to locale: English
\par (Canada) with the Short Date Format set to dd/mmm/yyyy (notice the three m's
\par to specify month name abbreviation), but the date is always shown on
\par SharePoint pages as dd/mm/yyyy (e.g. in document lists) - notice the two m's
\par for month number.
\par
\par What I specifically want is to make the date always show a Month
\par Abbreviation (e.g. Nov), but I can not find any setting anywhere that does
\par that.
\par
\par When English (Canada) is the locale for the site, dates show as dd/mm/yyyy.
\par When English(United States) is the locale for the site, dates show as
\par mm/dd/yyyy.
\par
\par As far as I'm concerned, neither of these is acceptable - they are
\par ambiguous - I should be able to tell SharePoint to always show the month
\par abbreviation. I can do this in Windows and all MS Office applications, so
\par it is very frustrating not to be able to do this with SharePoint.
\par
\par Why doesn't SharePoint use the settings from the Control Panel, Regional and
\par Language Options, Customize this format, Date, Short Date Format? This
\par setting is in Windows specifically so that one can specify the Date Format
\par one wants, but SharePoint is ignoring it.
\par
\par Please, exactly what steps are required to make SharePoint (V3 or MOSS 2007)
\par show dates with the month abbreviation instead of the month number?
\par
\par --
\par Bruce Sanderson
\par http://members.shaw.ca/bsanders/
\par It's perfectly useless to know the right answer to the wrong question.
\par
\par
\par ""Steven Cheng"" <stcheng@xxxxxxxxxxxxxxxxxxxx> wrote in message
\par news:tKP$8wfTJHA.6048@xxxxxxxxxxxxxxxxxxxxxxxxx
\par > Hi Brian,
\par >
\par > As for the window sharepoint site, you can check or change the current
\par > regional setting for a site as below:
\par >
\par > Do the following to change the regional setting for site:
\par >
\par > **Open the site on which you want to configure your regional settings.
\par > **click "Site Actions-->Site Settings" menu:
\par > **under " Site Administration " category, select "regional settings"
\par >
\par > and for indivual users, you can also set a user based preference regional
\par > setting:
\par >
\par > Do the following on each SharePoint site on which you want to configure
\par > personal regional settings:
\par >
\par > **Open the site on which you want to configure your personal regional
\par > settings.
\par > **At the top of the site, click the arrow next to Welcome User name, and
\par > then click My Settings.
\par > **On the User Information page, click My Regional Settings.
\par > **On the Regional Settings page, in the Follow Web Settings section, clear
\par > the Always follow web settings check box.
\par > **Select the settings that you want for this site, and then click OK.
\par >
\par > the datetime/number format should belong to the "locale" option in it.
\par >
\par > Sincerely,
\par >
\par > Steven Cheng
\par >
\par > Microsoft MSDN Online Support Lead
\par >
\par >
\par > Delighting our customers is our #1 priority. We welcome your comments and
\par > suggestions about how we can improve the support we provide to you. Please
\par > feel free to let my manager know what you think of the level of service
\par > provided. You can send feedback directly to my manager at:
\par > msdnmg@xxxxxxxxxxxxxx
\par >
\par > ==================================================
\par > Get notification to my posts through email? Please refer to
\par > http://msdn.microsoft.com/en-us/subscriptions/aa948868.aspx#notifications.
\par >
\par > Note: MSDN Managed Newsgroup support offering is for non-urgent issues
\par > where an initial response from the community or a Microsoft Support
\par > Engineer within 2 business day is acceptable. Please note that each follow
\par > up response may take approximately 2 business days as the support
\par > professional working with you may need further investigation to reach the
\par > most efficient resolution. The offering is not appropriate for situations
\par > that require urgent, real-time or phone-based interactions. Issues of this
\par > nature are best handled working with a dedicated Microsoft Support
\par > Engineer
\par > by contacting Microsoft Customer Support Services (CSS) at
\par > http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx
\par > ==================================================
\par > This posting is provided "AS IS" with no warranties, and confers no
\par > rights.
\par >
\par >
\par >
\par > --------------------
\par > From: "Bruce Sanderson" <bsanders@xxxxxxxxxxxxxxxx>
\par > References: <OjqOh00SJHA.5568@xxxxxxxxxxxxxxxxxxxx>
\par > <OQrB680SJHA.1160@xxxxxxxxxxxxxxxxxxxx>
\par > <#PndMR1SJHA.5904@xxxxxxxxxxxxxxxxxxxx>
\par > In-Reply-To: <#PndMR1SJHA.5904@xxxxxxxxxxxxxxxxxxxx>
\par > Subject: Re: Data Format on SharePoint pages - how to set
\par > Date: Fri, 21 Nov 2008 11:43:39 -0800
\par >
\par > Re-posting to additional newsgroups.
\par >
\par > --
\par > Bruce Sanderson
\par > http://members.shaw.ca/bsanders/
\par > It's perfectly useless to know the right answer to the wrong question.
\par >
\par >
\par > "Bruce Sanderson" <bsanders@xxxxxxxxxxxxxxxx> wrote in message
\par > news:%23PndMR1SJHA.5904@xxxxxxxxxxxxxxxxxxxxxxx
\par >> On the "web front end" server, in Control Panel, Regional and Language
\par >> Options, Current Format is English (Canada) and I've used the "Customize
\par >> this format..." dialog to set the Short Date Format to dd-mmm-yy.
\par >>
\par >> On the SharePoint site, in Site Actions, Site Settings, Site
\par >> Administration, Regional Settings, I've set the "Locale to English
\par >> (Canada) to correspond to the Control Panel, Regional and Language
\par >> Options, Current Format and Location. There is no option on MOSS Site
\par >> Settings, Regional Settings that I can find to specifically set the Date
\par >> Format.
\par >>
\par >> The date format on the SharePoint page is now dd-mm-yyyy, not dd-mmm-yy -
\par >> the format set in Control Panel for the Short Date is being ignored.
\par >>
\par >> Now, unless everyone is very careful, we will have a mixture of
\par > dd-mm-yyyy
\par >> and mm-dd-yyyy depending on what the site creator chooses. This will be
\par >> more confusing than ever!
\par >>
\par >> Surely, there has to be a way to convince MOSS to use a specific,
\par >> non-ambiguous, date format on all pages, unless a particular site owner
\par >> has deliberately changed it for a particular site.
\par >>
\par >> --
\par >> Bruce Sanderson
\par >> http://members.shaw.ca/bsanders/
\par >> It's perfectly useless to know the right answer to the wrong question.
\par >>
\par >>
\par >> "Brian Kenneth Nielsen" <bkn+msnewsgroup@xxxxxxxxx> wrote in message
\par >> news:OQrB680SJHA.1160@xxxxxxxxxxxxxxxxxxxxxxx
\par >>> Bruce Sanderson wrote:
\par >>>> I'm relatively new to SharePoint. We are planning on deploying
\par >>>> Microsoft Office SharePoint 2007. I've installed a Proof of Concept
\par >>>> "farm".
\par >>>>
\par >>>> On all of the servers and all of the client workstations, the Control
\par >>>> Panel, Regional and Language Options have the Short Date Format set to
\par >>>> dd-mmm-yyyy. I've used the option to have this format set for the
\par >>>> Default User and System Accounts (on Server 2008, this is done via the
\par >>>> "Copy to reserved accounts..." button on the Administrative tab of the
\par >>>> Regional and Language Options dialog). The servers are Windows Server
\par >>>> 2008 RTM 64 bit. The clients are either XP SP3 or Vista SP1. The
\par >>>> Regional and Language Options were set BEFORE SharePoint was installed.
\par >>>>
\par >>>> However, all date fields on the SharePoint pages show as mm-dd-yyyy,
\par >>>> which is ambiguous with respect to the day and month (e.g. 01-12-2008
\par >>>> could be 1 Dec 2008 or 12 Jan 2008).
\par >>>>
\par >>>> How do I convince MOSS to use the date format dd-mmm-yyyy (or any other
\par >>>> one I might choose) instead of the "default" format?
\par >>>>
\par >>>
\par >>> Hello
\par >>>
\par >>> Try and go to your site action menu, at click on Site Settings.
\par >>> There you will find a option to set the Localisation and Regional
\par >>> settings.
\par >>>
\par >>> MOSS won't recognize the browsers settings, but will use what is setup
\par > in
\par >>> the solution. You can set it for every web site in the Site Collection
\par >>>
\par >>> Best regards
\par >>> Brian Kenneth Nielsen
\par >>
\par >
\par >
\par
\par \pard
\par
\par }
Loading