Rainbow Portal

Re: How change date format

asaf meir — Thu, 21 May 2009 18:01:17 GMT

make sure to set the LANGUAGE or DATEFORMAT when working with MSSQL

SQLSERVER default englisg installation results in US style dates - mdy

Re: How change date format

ctheriault — Fri, 15 May 2009 13:30:41 GMT

Use "fr-CH" as culture for you user session (or for your whole appl) and you'll get this very format (I mean "dd.mm.yyyy"). It works fine for MaskEditExtender coupled with a MaskEditValidator and with CalendarExtender as well.

The "Mask" property seems subordinate to the current culture. "." will be display as separator when current culture is "fr-CH" regarless if you put an "/" in it. ("-" will be displayed if using the "fr-CA" culture (which is mine))

myControl_MaskedEditExtender.CultureName = MyCurrentSession.CurrentCulture.Name;
myControl_MaskedEditExtender.Mask = GetCurrentCultureShortDateMask();

Note: It seems for instance that Ajax needs "/" as separator in the Mask property otherwise I get runtime errors. I use something not very elegant instead, but that's the best I found so far:

    private string GetCurrentCultureShortDateMask()
    {
        bool bln_Got_d = false;
        bool bln_Got_M = false;
        string str_DataPattern = MyCurrentSession.CurrentCulture.DateTimeFormat.ShortDatePattern;
        StringBuilder sb_Mask = new StringBuilder(str_DataPattern.Length);
        foreach (char c in str_DataPattern)
            switch (c) {
                case 'y':
                    sb_Mask.Append('9'); break;
                case 'd':
                    if (bln_Got_d)
                        break;
                    bln_Got_d = true;
                    sb_Mask.Append("99");
                    break;
                case 'M':
                    if (bln_Got_M)
                        break;
                    bln_Got_M = true;
                    sb_Mask.Append("99");
                    break;
                default: 
                    sb_Mask.Append('/');
                    break;
            }
        return sb_Mask.ToString();
    }

Re: How change date format

vasanthiraajan — Fri, 06 Jun 2008 07:37:55 GMT

hi,

you can use the following,

DateTime dt = DateTime.Now;

string[] s = dt.Date.GetDateTimeFormats();

Response.Write(s[6].ToString() + "  ");

Response.Write(s[5].ToString() + "  ");

Response.Write(s[4].ToString() + "  ");

Response.Write(s[3].ToString() + "  ");

Response.Write(s[2].ToString() + "  ");

Response.Write(s[1].ToString() + "  ");

Response.Write(s[0].ToString() + "  ");

Re: How change date format

JimboM — Wed, 16 Jan 2008 22:37:35 GMT

You can use ToString with a format specifier...for example, to format this posting date in your format:

DateTime.Today.ToString("dd-MMM-yyyy")

Re: How change date format

satyanaresh — Mon, 05 Nov 2007 08:59:31 GMT

this is ok but i want my date format in dd-mon-yyyy

so what i can do

Re: How change date format

thanhtungo — Tue, 07 Jun 2005 05:03:15 GMT

You can change below:
if you want replace "31/12/2005" with "12/31/2005", you can see below code:

DateTime d1 = DateTime.ToDate;
string dd = d1.Day.ToString();
string mm = d1.Month.ToString();
string yyyy = d1.Year.ToString();

string d2 = dd + "/" + mm + "/" + yyyy;

Re: How change date format

pavel_2k — Wed, 25 May 2005 14:22:35 GMT

Problem in caching pages of portal. I change in web.config

<globalization culture="ru-RU" uiCulture="ru" requestEncoding="UTF-8" responseEncoding="UTF-8" fileEncoding="UTF-8" />
and
<add key="DefaultLanguage" value="ru-RU" />

and it's OK.

Many changes don't visible - until click "refresh" one+ times.

How change date format

pavel_2k — Wed, 25 May 2005 11:59:06 GMT

I localize my portal, but date in american format - mm/dd/yyyy.
How I can display date in dd.mm.yyyy format? When I input date in this format - it's verify on page - and write - "incorrect date".

Pavel