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

Posted on 2007-07-27
Last Modified: 2008-01-09
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?
Question by:ITBenelux
    LVL 12

    Expert Comment

    Open up the control panel and dbl click reginal settings,  On the date tab you can set the mask for the date.

    LVL 12

    Expert Comment

    Sorry you can set both the Long and Short date formats.
    LVL 25

    Accepted Solution

    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.
    LVL 12

    Expert Comment

    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.

    LVL 25

    Expert Comment


    He's using sharepoint 2007.

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

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
    We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
    This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
    In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now