ASP.NET MVC Core date only format is not working using DataAnnotation

Question

Following viewmodel used in a view is supposed to display a StartDate as, say 9/30/2015. But it is displaying as 9/30/2015 12:00:00 AM. How can I make it display without time while using DataAnnotaion? I know I can use @Model.StartDate.ToString("MM/dd/yyy") inside view to display date only. But that would mean you have to do it in every view that is using the following ViewModel:

ViewModel:

...
[DisplayFormat(DataFormatString = "{0:MM/dd/yyyy}")]
public DateTime StartDate { get; set; }
...

UPDATE

The corresponding model class of the above ViewModel already has the following DataAnnotation that correctly creates the data type in SQL Server table as Date; and when you run a query on the corresponding table in SSMS it correctly displays the StartDate column's data with dates only, say, 9/30/2015 etc.)

Model

...
[DataType(DataType.Date)]
public DateTime StartDate { get; set; }
...

StartDate in the sql db is in fact Date only. Moreover, if I run a query on SSMS it correctly returns date only.

Have you tried just using the [DataType(DataType.Date)] attribute? — Erik Funkenbusch
– Erik Funkenbusch, Commented Jul 28, 2017 at 17:05
@ErikFunkenbusch To answer your question, I've added an UPDATE section to my post. Moreover, I did try your suggestion on the ViewModel as well but to no avail. — nam
– nam, Commented Jul 28, 2017 at 18:09
Using the DataType attribute should work if your rendering with EditorFor or DisplayFor. — Erik Funkenbusch
– Erik Funkenbusch, Commented Jul 28, 2017 at 18:34
FYI, here's a fiddle that demonstrates dotnetfiddle.net/urdrHM — Erik Funkenbusch
– Erik Funkenbusch, Commented Jul 28, 2017 at 19:02
@ErikFunkenbusch In my view I'm using @Model.StartDate. Per your suggestion I should be using DisplayFor instead - correct? — nam
– nam, Commented Jul 28, 2017 at 19:26

Erik Funkenbusch · Accepted Answer · 2017-07-28 21:22:24Z

11

There are two solutions to your problem. As per your comments, you are currently using @Model.StartDate to display a date.

You can either do this:

@Model.StartDate.ToString("d")

Or, you can use a model based approach in your ViewModel and do this:

[DataType(DataType.Date)]
public DateTime StartDate {get;set;}

Then, in your view use:

@Html.DisplayFor(m => m.StartDate)

answered Jul 28, 2017 at 21:22

Erik Funkenbusch

93.7k29 gold badges201 silver badges292 bronze badges

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

1 Comment

nam Over a year ago

Last comment that you added in our chat room may answer my this. If you like you can write a response there and I'll mark that as an answer.

Collectives™ on Stack Overflow

ASP.NET MVC Core date only format is not working using DataAnnotation

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related