Change date format in ASP.NET MVC application

Question

I need to change date format to be dd.MM.yyyy. I am getting client side validation error because ASP.NET MVC date format is different from what I expect on the server.

In order to change ASP.NET MVC date format I tried:

Web.config:

<globalization uiCulture="ru-RU" culture="ru-RU" />

Model:

[DataType(DataType.Date)]
[DisplayFormat(DataFormatString = "{0:dd.MM.yyyy}", ApplyFormatInEditMode = true)]
public DateTime? ServiceCreatedFrom { get; set; }

Editor template:

@model DateTime?
@Html.TextBox(string.Empty, (Model.HasValue 
    ? Model.Value.ToString("dd.MM.yyyy")
    : string.Empty), new { @class = "date" })

View:

@Html.EditorFor(m => m.ServiceCreatedFrom, new { @class = "date" })

Even Global.asax:

public MvcApplication()
{
    BeginRequest += (sender, args) =>
        {
            var culture = new System.Globalization.CultureInfo("ru");
            Thread.CurrentThread.CurrentCulture = culture;
            Thread.CurrentThread.CurrentUICulture = culture;
        };
}

Nothing worked for me.

i had a similar problem: stackoverflow.com/questions/13623381/… — NickD
– NickD, Commented Jun 14, 2013 at 10:36

Darin Dimitrov · Accepted Answer · 2013-06-14 10:17:42Z

15

The following should work:

[DataType(DataType.Date)]
[DisplayFormat(DataFormatString = "{0:dd.MM.yyyy}", ApplyFormatInEditMode = true)]
public DateTime? ServiceCreatedFrom { get; set; }

and in your editor template:

@model DateTime?
@Html.TextBox(
    string.Empty, 
    ViewData.TemplateInfo.FormattedModelValue, 
    new { @class = "date" }
)

and then:

@Html.EditorFor(x => x.ServiceCreatedFrom)

The second argument you were passing to the EditorFor call doesn't do what you think it does.

For this custom editor template, since you specified the format explicitly on your view model property the <globalization> element in your web.config and the current thread culture will have 0 effect. The current thread culture is used with the standard templates and when you didn't override the format with the [DisplayFormat] attribute.

answered Jun 14, 2013 at 10:17

Darin Dimitrov

1.0m276 gold badges3.3k silver badges3k bronze badges

Sign up to request clarification or add additional context in comments.

11 Comments

sammy34 Over a year ago

Hehe I knew somebody would be quicker :).

Andrei Over a year ago

Thanks for the answer. But I am still getting validation exception, just because app expects MM.dd.yyyy

sammy34 Over a year ago

Would it be overkill to add a custom model binder for this case? I'm not sure if the default model binder considers the current culture.

Darin Dimitrov Over a year ago

Yes, the default model binder uses the current culture. But there's one more ting to the picture that you should not forget. If you enabled client side validation (unobtrusive javascript) then the date is parsed on the client, using the client browser culture. So if you are using client side validation you will also have to write a custom rule to parse the date on the client using the specified format instead of using the browser settings.

Darin Dimitrov Over a year ago

You will have to write a custom date parsing method for the jquery.validate plugin that you are using: stackoverflow.com/questions/11756226/…

|

RAVI VAGHELA · Accepted Answer · 2015-12-30 14:04:29Z

2

You can change the current culture in your Global.asax file, for application level For Example,

using System.Globalization;
using System.Threading;

protected void Application_BeginRequest(Object sender, EventArgs e)
{    
  CultureInfo newCulture = (CultureInfo) System.Threading.Thread.CurrentThread.CurrentCulture.Clone();
  newCulture.DateTimeFormat.ShortDatePattern = "dd-MMM-yyyy";
  newCulture.DateTimeFormat.DateSeparator = "-";
  Thread.CurrentThread.CurrentCulture = newCulture;
}

answered Dec 30, 2015 at 14:04

RAVI VAGHELA

8971 gold badge10 silver badges12 bronze badges

Comments

sammy34 · Accepted Answer · 2013-06-14 10:28:18Z

1

As a potential aid for identifying the issue, are you able to: 1. Set a breakpoint at the point where you're trying to format the date 2. Use something like the Immediate Window in Visual Studio to evaluate the value of

Thread.CurrentThread.CurrentCulture.Name

If you do this, does it come back with the "ru-RU" culture?

I'm sure I'm not the only one that would be happy to help you work through debugging this. That said, perhaps somebody quicker than me can see the problem straight away :).

Edit: It looks like you're using Razor, so you should be able to set a breakpoint directly in the view file on the line where you're trying to format the date.

Edit #2:

There may be a cleaner way to do this, but if the form data is being posted in dd.MM.yyyy then you might need a custom model binder, something like:

public class CustomModelBinder : DefaultModelBinder
    {
        public override object BindModel(ControllerContext controllerContext, ModelBindingContext bindingContext)
        {
              // custom bind the posted date    
        }
}

...which would then get assigned as a model binder in e.g. ApplicationStart in Global.asax.cs.

Let me know if you think this might help and I can elaborate.

edited Jun 14, 2013 at 10:28

answered Jun 14, 2013 at 10:16

sammy34

5,5975 gold badges35 silver badges49 bronze badges

1 Comment

Andrei Over a year ago

The culture is ru-RU. I've checked :)

Community · Accepted Answer · 2017-05-23 10:31:16Z

1

finally this one worked for me to get this dd/mm/yyyy format i used date = string.Format("{0}/{1}/{2}", Model.Value.Day, Model.Value.Month, Model.Value.Year);

first create EditorTemplates folder in Sharedfolder, then create a Datetime editor template in Sharedfolder/EditorTemplates/Datetime.cshtml then follow the above link.

in view

@Html.EditorFor(x => x.ServiceCreatedFrom)

hope helps someone.

edited May 23, 2017 at 10:31

CommunityBot

11 silver badge

answered Mar 30, 2015 at 15:28

Shaiju T

6,65324 gold badges112 silver badges201 bronze badges

Collectives™ on Stack Overflow

Change date format in ASP.NET MVC application

4 Answers 4

11 Comments

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

11 Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related