Entity Framework DateTime format when editing entry

asp.net asp.net-mvc-5 date entity-framework

Question

I have a Timetable model which only has two attributes at the moment, an Id and Date. It's defined as so:

public class Timetable
{
    public int Id { get; set; }

    [Required, Column(TypeName = "Date"), DisplayFormat(DataFormatString = "{0:dd/MM/yyyy}")]
    public DateTime Date { get; set; }
}

I then scaffolded some basic CRUD functionality, and thanks to the DisplayFormat annotation it's allowing me to create timetables with dates in the dd/MM/yyyy format. However, when I edit an existing timetable, the application is populating the Date text box with 01/01/2015 00:00:00 (see screenshot).

enter image description here

Is there any way to make my application only use the date, rather than date and time?

1
0
1/17/2015 11:08:11 PM

Accepted Answer

In order to render the browsers datepicker (<input type="date" ..>) using EditorFor() you need the following attributes on the property (note the ISO format means the date will be displayed in accordance with the browser culture)

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

and in the view

@Html.EditorFor(m => m.Date)

Note the HTML5 date input is not supported in older browsers, and not at all in FireFox - see comparison here

6
1/17/2015 11:28:11 PM


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow