asp mvc EditorFor DateTime not displaying

Question

I am trying to display a datetime field retrieved froma database in my razor file with the following:

 @Html.EditorFor(model => model.RequestDate);

I know with 100% certainty the RequestDate is not null, as I examined the model that was passed in the view, and it was the date from the database. However, the datetime textbox still displays "mm/dd/yyyy". I don't know why it is not display the date. Any ideas? Thank you.

Here is my model:

      [Display(Name = "Time")]
    [DataType(DataType.Date)]
    public DateTime RequestDate { get; set; }

EDIT:

   [HttpGet]
    public ActionResult DispatchResponseIndex()
    {
        DispatchResponseModel model = new DispatchResponseModel();       


        //if the users session id isnt null then we know they have data related to this form
        object UserID = Session["TestID"];
        if (UserID == null)
        {
            return View(model); //default view               
        }
        else
        {
            UserID = Session["TestID"];
        }

        LoadDB(model, (Guid)UserID);
     //looking at the model here the RequestDate has a valid date of  //{5/24/2013 12:00:00 AM}

        return View(model); 
    }

EDIT 2:

If I use @Html.TextBox("asdasd",Model.RequestDate); Then it will display the saved date in string format, but I need to use the built in date editor for the text box.

Could you elaborate a little? I have been using MVC for a week. I set the RequestDate in my controller and passed it into the view. Is this not enough? — John Edwards
– John Edwards, Commented May 30, 2013 at 18:32
it should be enough but, check in your model you have and what annotation you added it could be something with the DisplayFormat — Jorge
– Jorge, Commented May 30, 2013 at 18:35
Can you show us how you're passing the model to your View? Just to rule out any errors there — Kenneth
– Kenneth, Commented May 30, 2013 at 18:39

plr108 · Accepted Answer · 2019-09-27 07:26:48Z

28

This does seem to cause a lot of confusion and it annoyed me!

If you use DataType.Date you need to set it like this:

[DataType(DataType.Date)]
[DisplayFormat(DataFormatString = "{0:yyyy-MM-dd}", ApplyFormatInEditMode = true)]

Chrome's date picker uses the local computer's short date format. Even setting the lang tag is ignored; here is an example using Chrome and <html lang="en-GB">:

enter image description here

Chrome's date picker also uses the local computer's locale. On page load, the date will be populated (if set) and the user can select a new date:

enter image description here

Note: If you change the computer's locale you must restart Chrome completely to see the locale change.

edited Sep 27, 2019 at 7:26

plr108

1,22511 silver badges16 bronze badges

answered Apr 30, 2014 at 21:04

Piotr Kula

9,8918 gold badges62 silver badges87 bronze badges

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

1 Comment

Dave_cz Over a year ago

Sadly, this solution also affects DisplayFor(), so all your dates will display in this international format.

John Edwards · Accepted Answer · 2013-05-30 19:48:13Z

16

FINAL

I'm an idiot. I had no idea Chrome had a date picker that it added. I thought it was something built into MVC. I need to use an actual jquery date picker. Thanks everyone for all the info.

answered May 30, 2013 at 19:48

John Edwards

1,5463 gold badges15 silver badges33 bronze badges

2 Comments

Maxito Over a year ago

You're not the only one, just happened to me and this comment helped me realize it.

Piotr Kula Over a year ago

Its HTML5 Datepicker which each HTML5 browser implements its self. Differently for Mobile and Desktop too, so its native to the platform and set the the locale properly. It took me a while to work out what was going on with this too. But once you know, your the boss.

score 4 · Accepted Answer · 2013-05-30 19:27:20Z

4

Add Format line in you model

[Display(Name = "Time")]        
[DisplayFormat(ApplyFormatInEditMode = true, DataFormatString = "{0:MM/dd/yyyy}")]
[DataType(DataType.Date)]
public DateTime RequestDate { get; set; }

Update

OR

Can you change the model property datetime to string. and convert your datetime object to string !!

OR

Or you can format that value in your editor field .for sample like

@Html.TextBoxFor(model => model.FromDate, "{0:d}")

edited May 30, 2013 at 19:27

answered May 30, 2013 at 18:59

user1193035

8 Comments

John Edwards Over a year ago

I tried this, and it still just displays "mm/dd/yyyy".It is getting very peculiar. I am using [DataType(DataType.Date)] so I can have the built in date editor.

user1193035 Over a year ago

Can you change the model property datetime to string. and convert your datetime object to string !!

John Edwards Over a year ago

So you want me to say "public String RequestDate { get; set; }"?Because that removes the date editor.

user1193035 Over a year ago

Yes . Or you can format that value in your editor field .for sample like @Html.TextBoxFor(model => model.FromDate, "{0:d}")

John Edwards Over a year ago

Hm, I tried @Html.TextBoxFor(model => model.RequestDate, "{0:d}" and it displays a date, but there is no longer any date dropdown for that text box.

|

slfan · Accepted Answer · 2013-08-08 18:24:29Z

2

I had this exact same problem. If you look at the HTTP Post that was going back to the Controller and the format of the date in the POST it is yyyy-MM-dd.

I changed my data annotation to this and it worked ... Except now the Index list view shows yyyy-mm-dd format. And the Edit shows mm/mm/yyyy in a datepicker control?

Added to Model Date -

[DisplayFormat(ApplyFormatInEditMode = true, DataFormatString = "{0:yyyy-MM-dd}")

IMHO EVERY app I've seen since 1980 has used dates and times. Why is this still a mess Mr MS?

edited Aug 8, 2013 at 18:24

slfan

9,129115 gold badges69 silver badges81 bronze badges

answered Aug 8, 2013 at 18:01

Mark

211 bronze badge

Comments

karl li · Accepted Answer · 2014-08-11 00:19:20Z

2

Actually until I saw this post, I didn't realise there's "date picker" difference between Chrome and IE, even though I got the sample page layout from the MVC's tutorial.

For someone who doesn't realise the difference, as I did before, please find below the comparison:

enter image description here

answered Aug 11, 2014 at 0:19

karl li

1,52616 silver badges22 bronze badges

Comments

Robert · Accepted Answer · 2015-09-11 13:52:43Z

1

This is how i do it inside the model

[Display(Name = "Effective Date")]
    [DataType(DataType.Date)]
    [DisplayFormat(ApplyFormatInEditMode = true, DataFormatString = "{0:dd-MMM-yyyy}")]
    public DateTime? Effectivedate 
    {
        get { return EffectivedateEdit; }
        set { EffectivedateEdit = value; EffectivedateEdit = value; } 
    }


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

edited Sep 11, 2015 at 13:52

Robert

5,31843 gold badges70 silver badges115 bronze badges

answered Sep 11, 2015 at 13:36

Rumesh Silva

111 bronze badge

Comments

Victor · Accepted Answer · 2021-06-15 16:32:40Z

1

DataFormatString MUST be EXACT like this "{0:yyyy-MM-dd}" then and only then @Html.EditorFor works with date picker control.

answered Jun 15, 2021 at 16:32

Victor

192 bronze badges

Comments

Truong Mai Van · Accepted Answer · 2021-11-21 23:52:32Z

It also take me about 5days to find out how make it done, so may be help someome

first in Model you should have line : [DataType(DataType.Date)]

Then in View, you shoud user @Html.TextBoxFor instead of @Html.EditorFor

enter 

    [DataType(DataType.Date)]
    public DateTime Expireddate { get; set; }

code here

inview as below:

enter  <td>

                  
                    @Html.TextBoxFor(modelItem => item.Expireddate.Date, "{0:yyyy-MM-dd}",

                  new
                  {
                      onkeydown = "return  event.keyCode != 13",
                      @class = "form-control datepicker",
                      @type = "date",
                      @value = ToolShare.datetoStringyyyymmddviewnet(@item.Expireddate.Date),
                      id = @item.id,
                      onChange = "replaceContentsOfDivupdateExpireddate(this.id, this.value)"

                  })


                    @Html.ValidationMessageFor(modelItem => item.Expireddate)
                </td>

code here

function datetoStringyyyymmddviewnet to convert datetime to string like : yyyy-mm-dd

enter  public static String datetoStringyyyymmddviewnet(DateTime datevalue)
    {

        // yyyy-mm-dd  to date

       

        return datevalue.Year +"-" + datevalue.Month +"-"+ datevalue.Day;
    }

code here

Collectives™ on Stack Overflow

asp mvc EditorFor DateTime not displaying

8 Answers 8

1 Comment

2 Comments

8 Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

8 Answers 8

1 Comment

2 Comments

8 Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related