[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1513
  • Last Modified:

Change Date format from numbers to letters (e.g. Jan,17th 2007 instead of 01/07/2007)

Hi everyone,
We have Sharepoint 2007 server, and created a small project task list.  We use start and end-date to keep track of projects.  By default, Sharepoint shows the dates in a numerical way (01/02/2007).  However, we are a European office of an American company (we use DD/MM/YY, US uses MM/DD/YY).  To avoid misinterpretations, we would like to display dates with letters (Monday, April,...) Can anybody help us with this?
  • 3
  • 2
1 Solution
Open up the control panel and dbl click reginal settings,  On the date tab you can set the mask for the date.

Sorry you can set both the Long and Short date formats.
You need to have a date field which is "today's" date. Then you need to create a second field which is a calculated field, and a single line of text. You then need to use this formula:


That will display the date as: Monday, 06 Jan 2007
for example.
Sorry for the delay, fell asleep waiting to reconnect to EE.(it was that or go through withdrawls)

As sited from
International Features in SharePoint Portal Server 2003

Locale-Based Formatting
Locale support in SharePoint Portal Server 2003 allows you to use regional settings to define how a set of information is presented to users. Information that can be defined is formatted based on the locale that the portal site administrator implements, and it includes:
How dates are formatted
How the time is formatted
The time zone of the site
How items are sorted
How numbers are formatted
The information is affected in the following ways:
Date format   How the date is formatted throughout the site. For example, if a portal site is set to the English (United Kingdom) locale, all dates within the portal site are formatted as DD-MM-YYYY.
Calendar format   How the year is formatted. SharePoint Portal Server 2003 supports five calendar formats: Gregorian, Hijri, Hebrew Lunar, Buddhist, and Saka Era. These calendar options are available only when certain locales are selected.
Time format   How the time is formatted. The time format can be either a 12-hour format or a 24-hour format. These options are available only when specific locales are selected. The default format is the 24-hour format.
Time zone   The time zone for the site. The default time zone is based on the primary language of the SharePoint Portal Server 2003 installation. For example, SharePoint Portal Server installed in German defaults to the German (Germany) locale and uses the time zone (GMT+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna. Countries that do not automatically adjust for daylight saving time can manually adjust the Timezone.xml file in the following location: Program Files\Common Files\Microsoft Shared\web server extensions\60\Config.
Sort order   The sort order for the site. The sort order is based on the SQL Server collation order. When a locale is selected, the matching sort order is selected based on the SQL Server collation order, which is defined with the Windows collation designator. The sort order governs how items, lists, and areas are sorted on the site. The collation order is width, accent, and kana sensitive. The collation order is not case sensitive and does not support the binary sort order. Programmatically setting the sort order to something other than case insensitive is not supported.
Number format   The format of numbers on the site. Most numbers are formatted based on the locale of the portal site. For example, if the portal site locale is set to English (United Kingdom), numbers are formatted as N,NNN.NN.
You can set the regional settings on a portal site or My Site only. However, each site that you create within a portal site can have different regional settings.
Caching issues may be experienced on the portal site. If you made a change and the page does not reflect this change, press F5 to refresh the page.
Locale Support in Backing Up and Restoring a Portal Site
Backup and restore is based on the user locale of the computer on which SharePoint Portal Server is installed. The backward-compatible document library is based on the language of the document library installation.
Portal Site Settings
To configure regional settings on the portal site, follow these steps:
1.On the Site Settings page, in the General Settings section, click Manage security and additional settings.
2.On the Mange security an additional settings page, in the Regional Settings section, click Modify regional settings.
3.On the Regional Settings, page, choose the regional settings you want.
4.Click OK to ensure that the settings are propagated throughout the entire portal site, including subwebs.
My Site Settings
To configure regional settings on My Site, follow these steps:
1.On the Site Settings page, in the Administration section, click Go to Site Administration.
2.On the Top-level Site Administration page, in the Management and Statistics section, click Change regional settings.
3.On the Regional Settings page, choose the regional settings you want.
SharePoint Portal Server Central Administration Settings
On the Propagation page (Propcentral.aspx), dates for each of the listed portal sites are formatted based on the locale of the portal site. For example, if you have two portal sites, where the locale of the first site is set to English (United Kingdom) and the locale of the second site is set to English (United States), the date is formatted as follows on the Propagation page:
    English (United Kingdom):        DD/MM/YYYY
    English (United States):            MM/DD/YYYY
Note   The Propagation link (Propcentral.aspx), which is accessible from the Configure Search and Indexing page, is visible only in a medium farm deployment.


He's using sharepoint 2007.

The formula is incredibly easy. I use it myself to great effect.

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now