About Date Format

Question

i am storing date in sql database. @Html.TextBoxFor(Model => Model.StartDate, new { @class = "form-control form-control-lg", @id = "txtStartDate", @type = "date" }) It is working while saving date to database. But while Editing the record it does not fetch date in that textbox.it is coming as follows.Please find attachment. thanks in advance

Jignesh Kumar · Answer

Could you please remove annotation for datatype.? For 1 option. just try with this and apply formatstring same for both model and razor. [DisplayFormat(DataFormatString = "{0:yyyy-MM-dd}" , ApplyFormatInEditMode = true )] public DateTime StartDate { get ; set ; } @Html.TextBoxFor(Model => Model.StartDate, new { @type= "date" , @ class = "form-control datepicker" , @Value = Model => Model.StartDate.ToString( " 0: yyyy-MM-dd" ) } )

Guest User · Answer

hey Jignesh Kumar, Thanks for your reply. I have tried the way you asked, but still, it retrieves the date as "mm/dd/yyyy" in the textbox. It should actually fetch the date like 03/07/2019 something like this.But it fetches mm/dd/yyyy. Advice needed. Thank You

Guest User · Answer

Thanks for reply. I have tried both ways : 1) [DataType(DataType.Date)] [DisplayFormat(DataFormatString = "{0:yyyy-MM-dd}", ApplyFormatInEditMode = true)] public DateTime StartDate { get; set; } 2) public DateTime StartDate { get; set; }

Jignesh Kumar · Answer

What is type of your field in model ? Could you please share model as well. ?

Guest User · Answer

hey, thanks for a reply. The below code is not working. I have tried that. It's biding same date type textbox in that format. Please find attachment below. It should bind date like 03/16/2019

Jignesh Kumar · Answer

Hi Sushant, Please try this link, its problem with @type="Date" @Html.TextBoxFor( Model => Model.StartDate , new { @type= "date" , @ class = "form-control datepicker" , @Value = Model => Model.StartDate .ToString( "yyyy-MM-dd" ) } ) @Html.ValidationMessageFor( Model => Model.StartDate , "" , new { @ class = "text-danger" }) https://stackoverflow.com/questions/25086909/how-to-use-html-textboxfor-with-input-type-date/25087223