MVC TextBoxFor display date format instead of value

Question

I’m working on ASP.NET application, and I have an issue with date formatting. TextBoxFor is displaying Date Format instead of date.

Regional Settings:

United Kingdom, date format: “yyyy-mm-dd”.

.NET Globalization - IIS Settings:

Culture:                       Invariant Language (Invariant Country)
Enable Client Based Culture:   false
UI Culture:                    Invariant Language (Invariant Country)
File:                          Windows-1252
Requests:                      utf-8
Response Headers:              utf-8
Responses:                     utf-8

MainView (I have tried ToShortDateString() and ToString("d")) :

<td>
    @item.InvoiceDate.ToShortDateString()
</td>
<td>
    @item.DueDate.ToString("d")
</td>

Edit View:

<div class="form-group">
       <div class="col-md-10">
             @Html.Label("Invoice Date:")
             <div class="fiveSpace"></div>
             @Html.TextBoxFor(model => model.InvoiceDate, "{0:d}", new { type = "date" })
             @Html.ValidationMessageFor(model => model.InvoiceDate)
       </div>
</div>

<div class="form-group">
       <div class="col-md-10">
             @Html.Label("Due Date:")
             <div class="fiveSpace"></div>
             @Html.TextBoxFor(model => model.DueDate, "{0:d}", new { type = "date" })
             @Html.ValidationMessageFor(model => model.DueDate)
       </div>
</div>

Model:

[Required(ErrorMessage = "Please select Invoice Date.")]
public DateTime? InvoiceDate { get; set; }
[Required(ErrorMessage = "Please select Due Date.")]
public DateTime? DueDate { get; set; }

And result: Table row

Once I try to edit dates: Date and Inspect element

Correct value is stored in "value" but TextBoxFor displays date format. Also, when I have changed regional setting to other country, in MainView I always received dates in format "dd/mm/yyyy" and in edit view dates were displayed with US format, "mm/dd/yyyy".

I have tried:

set up <globalization uiCulture="en-GB" culture="en-GB" /> in web.config
add [DisplayFormat(DataFormatString = "{0:d}"] to model

Is the problem on my side, or IIS?

kasjer · Accepted Answer · 2020-09-30 15:39:47Z

1

Resolved.

I've replaced mentioned TextBoxFor with:

@Html.TextBoxFor(model => model.InvoiceDate, new { @type = "date", @Value = Model.InvoiceDate.Value.ToString("yyyy-MM-dd") })

and it works.

answered Sep 30, 2020 at 15:39

kasjer

411 silver badge3 bronze badges

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

Comments

Oleksandr Herashchenko · Accepted Answer · 2020-09-29 20:14:31Z

0

The TextBoxFor with type="date" converts it to the <input type="date"> HTML tag which doesn't support date format customization according to the MDN.

It can be achieved by some 3rd-party JS libraries like Masked Input Plugin for jQuery or datetime-input web component

answered Sep 29, 2020 at 20:14

Oleksandr Herashchenko

262 bronze badges

Collectives™ on Stack Overflow

MVC TextBoxFor display date format instead of value

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related