CODEWITHSUNDEEP
asp.net-mvcrazor
John Edwards
John Edwards

Reputation: 1546

asp mvc EditorFor DateTime not displaying

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.

Upvotes: 17

Views: 39732

Answers (8)

Truong Mai Van
Truong Mai Van

Reputation: 147

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

Upvotes: 0

Victor
Victor

Reputation: 19

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

Upvotes: 1

Piotr Kula
Piotr Kula

Reputation: 9811

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.

Upvotes: 28

Rumesh Silva
Rumesh Silva

Reputation: 11

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; }

Upvotes: 1

karl li
karl li

Reputation: 1476

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

Upvotes: 2

Mark
Mark

Reputation: 11

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?

Upvotes: 1

John Edwards
John Edwards

Reputation: 1546

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.

Upvotes: 16

user1193035
user1193035

Reputation:

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}")

Upvotes: 4

Related Questions