About Date Format

Guest User

7y2.5k.NET

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

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Guest User7y ago
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
Jignesh Kumar7y ago
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 User7y ago
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 Kumar7y ago
What is type of your field in model ? Could you please share model as well. ?
Guest User7y ago
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 Kumar7y ago
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