.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Regional settings (locale) in SP - is there any way to change that settings? eg. date format

Posted By:      Posted Date: October 28, 2010    Points: 0   Category :SharePoint
The system I use is MOSS2007. I have regional settings set to "Polish". The default date format is yyyy-mm-dd, what is wrong because usually is dd-mm-yyyy. Is there any way to change specific regional settings? I couldn't have found it on internet. I've tried to change to "French", which gives me dd-mm-yyyy, but then eg. in calendar I have days and months in French language :)

View Complete Post

More Related Resource Links

Change Regional Settings

I need to change regional settings on SharePoint so that the date format is not mm/dd/yyyy but dd/mm/yyyy.I have seen that this can take place if i go to Home site->Site Settings->Regional Settings and change the locale from there. All are perfect up to here. Since i need this change to take effect on subsites as well I check the "All sub-sites inherit these Regional Settings". After Pressing ok, i get an error message "Please turn off all indexed columns before changing the collation of this site. One or more list or library contains a column that has been marked for indexing. ..."How can i stop this indexing temporary? i tried to stop the indexing service from service administration but this didn't work.After applying this change, i hope my dates will not be lost, correct (this is the production server.....)? Will i have any problem with the search? Do i need further actions?a.rongas

Dynamic list item title based on date created & regional settings?

I have a list of things that doesn't *need* a title.  However, because sharepoint uses Title for links, RSS etc  I tried generating a title in an event handler.   This would work great if I wasn't basing it on a date field: public override void ItemAdding(SPItemEventProperties properties) { DateTime dt = Convert.ToDateTime(properties.AfterProperties["TestDate"]); properties.AfterProperties["Title"] = dt.ToShortDateString(); base.ItemAdding(properties); } In testing, this sets the title to "8/9/2010" when I selected 8/10/2010 in the date picker.  I figure this is because of the regional settings of my test user.  I can probably correct the title value for 'test user' but that won't fix 'test user in mongolia' who would still see two different values. So What I would like is to have the Title always display the value MyDate in the uesr's locale.  So the field needs to be dynamic not only at edit/update time, but at display time. Does anybody know if this can be accomplished, and more specifically how?

Convert English to Arabic number without changing any regional settings in .net

Well, most applications that I worked with was multilingual that supports English UI and Arabic UI.

And one of the major issue that we have faced is displaying Arabic numbers without the need of changing the regional settings of the PC.

So the code below will help you to display Arabic number without changing any regional settings.

how to change date format

Hi,   I am using Oracle 10g im my asp.net project. In my select query, i want to change the format to dd/mm/yyyy hh:mm:ss from mm/dd/yyy hh:mm:ss. The field datatype is date. How can i write a query for this?

How do I change the top menu navigation for layouts like Site Settings?

I used something similiar to what Kalik posted on this thread, however, I'm not seeing the same results in layouts like Site Settings.  Any answers would be appreciated. Thank you, Mike ADD TO TOP LINE! <%@ Register Tagprefix="PublishingNavigation" Namespace="Microsoft.SharePoint.Publishing.Navigation" Assembly="Microsoft.SharePoint.Publishing, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> ADD IN HEADER AREA! <PublishingNavigation:PortalSiteMapDataSource ID="siteMapDataSource1" runat="server" SiteMapProvider="CombinedNavSiteMapProvider" EnableViewState="true" StartFromCurrentNode="true" StartingNodeOffset="0" ShowStartingNode="false" TreatStartingNodeAsCurrent="true" TrimNonCurrentTypes="Heading"/> </HEAD> REPLACE STANDARD TOP NAV CODE! <!--- Modified Top Nav ---->    <SharePoint:aspmenu    ID="GlobalNav"    Runat="server"    DataSourceID="siteMapDataSource1"    Orientation="Horizontal"     MaximumDynamicDisplayLevels="1"     StaticPopoutImageUrl="/_layouts/images/menudark.gif"    StaticSubMenuIndent="0px"  &nb

how do i change date format??


hey Guys,

I have a table with a date field that had date saved in the format of
yyyy-mm-dd, what i want to achieve is when I display them I want them to be displayed as an example "September 05 2009" format. can anybody help me with this??

Thank you very much.

How to change the date format using AJAX calendar control tookit


I want to desplay date like (21-Sep-2010)

How programmatically change Additional Column Settings - Show field?


Hello. I use the SPFieldUser in my list. I can change Additional Column Settings - Show field: "Name with Presense" on the "Name (with Picture and details)" using the WSS Web interface. How do it programmatically, using Object Model WSS?

Regional settings impacts Caml DateTime query



I am using the GetListItems web service to retrieve items from a list where my custom column UpdateCompleted is less than or equal to a given datetime. But, I noticed some weird behaviour of SharePoint 2007 going on. The query would perform differently when I changed my regional settings on the site settings page of SharePoint! When regional settings were set to UTC my query would select the items, when in GMT it would not.

I have specified my query to use a DateTime in UTC form (ends with Z) and I have also specified DateInUtc to TRUE in the query options. So I would expect SharePoint to do a UTC date compare despite what the site regional settings are set to.

This is my query:

<Query><Where><And><Eq><FieldRef Name='Status'></FieldRef><Value Type='Text'>Unlocked</Value></Eq><Leq><FieldRef Name='UpdateCompleted'></FieldRef><Value Type='DateTime' IncludeTimeValue='TRUE'>2010-10-08T18:40:21Z</Value></Leq></And></Where></Query>

This is my query options:

Using Custom Regional Settings in WPF


I am creating a localized WPF application and i want WPF to use whatever settings i have in my regional settings.

All over the internet they recommend the following code, which i did use

protected override void OnStartup(StartupEventArgs e)
    new FrameworkPropertyMetadata(

Now, let's suppose that in the regional settings i'm still using en-US but i have decided to show the currency as 1 digit after the decimal point instead of 2

If i use this code, it works perfectly

decimal d = 2.5M;

but when i use binding, i still get both digits after the decimal point


How to change a date format in GridView?


Hello all,

I'm new here - just started, and already have a problem...


From the database - 2 of my GridView cells: From Period, and Till Period - retrieve dates in the format YYYYMM - that is: just Year and Month. For Example:

Till Period
From Period

  200008 200005

  200011 200009


I want for the date to be displayed in the Grid at the following format MM/YYYY - that is:

Date Format Change in GridView


Hello all,

I'm new here - just started, and already have a problem...

From the database - 2 of my GridView cells: From Period, and Till Period - retrieve dates in the format YYYYMM - that is: just Year and Month. For Example:

Till Period
From Period
Till Period
From Period

  200008 200005

  200011 200009


I want for the date to be displayed in the Grid at the following format MM/YYYY - that is:

Till Period
From Period

My regional Settings


On our Project 2010 site only users with contribute permissions have the option to change their regional setting through the users My Settings properties , but users with more restrictive  access to the site do not see the option to change their My regional settings . They only see the My Alerts . is there a way to enable this for all users ?

Change the date format of calendar web part



I have displayed summary view of calendar web part and want to change the date format from 10-24-2010 to 10-24 I don’t want to display the year can anyone help me please


Forms Services Regional Settings


When a user selects a date with the Date Picker control, the date is entered as mm/dd/yy. In Australia we use a slightly reversed date format to the default US setting: dd/mm/yy.

I have checked the regional settings in the following placed, but they're all set to Australia:
1. The SharePoint site that's hosting my form (i.e. the list that has my form as a content type).
2. The SharePoint front-end web server that's hosting the SharePoint web application.
3. My local PC.

Is there some other place I need to set the region?



Change date format


I am getting date on my aspx page as

10/22/2010 11:52:07 AM

How can i change the format so that i becomes:

22 Oct 2010 11:52 AM


Plz help me to change date format


                <div style="width:100%; height:150px; background-color:#cae2eb;">
                    <div style="float:left; margin-left:10px; text-align:center; height:150px; width:400px; margin-top:5px;">
                        <p style="font-weight:bold; padding-top:10px;"><%#DataBinder.Eval(Container.DataItem, "EventFrom").ToString("MMM dd, yyyy")%></p>
                        <p style=&quo
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend