Assign format of DateTime with data annotations?

Question

I have this attribute in my view model:

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

If I want to display the date, or populate a textbox with the date, I have these:

<%: Model.StartDate %>

<%: Html.TextBoxFor(m => m.StartDate) %>

Whenever the date is displayed, it's displayed like: 01/01/2011 12:00:00 AM

But I'd like to only display 01/01/2011

Is there a way to apply a display format with data annotations? I don't want to have to go to every instance where I display a date, and add some code to format it.

duplicate? stackoverflow.com/questions/1961114/date-only-from-textboxfor — David Fox
– David Fox, Commented Mar 9, 2011 at 22:26

David Fox · Accepted Answer · 2011-03-09 22:27:53Z

170

Try tagging it with:

[DisplayFormat(ApplyFormatInEditMode = true, DataFormatString = "{0:MM/dd/yyyy}")]

answered Mar 9, 2011 at 22:27

David Fox

10.8k9 gold badges53 silver badges80 bronze badges

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

7 Comments

Steven Over a year ago

Just tried that, it still displays the time in the TextBox and when it's just displayed on the page.

David Fox Over a year ago

@Steven: Can you try removing [DataType(DataType.DateTime)] if you haven't already?

Ε Г И І И О Over a year ago

DisplayFormat works only with EditorFor and DisplayFor helpers.

CodeHxr Over a year ago

Great answer - I was missing the "ApplyFormatInEditMode" parm.

Caffeinius Over a year ago

I was able to resolve this by format parameter in Html.TextBoxFor. By setting it to @Html.TextBoxFor(model => model.YOUR_DATE, "{0:MM/dd/yyyy}") I was able to get just the date to display. Found this here [stackoverflow.com/a/14529347/2938775].

|

rk1962 · Accepted Answer · 2011-07-30 00:52:29Z

61

Did you try this?

[DataType(DataType.Date)]

answered Jul 30, 2011 at 0:52

rk1962

1,7933 gold badges24 silver badges29 bronze badges

1 Comment

AaronLS Over a year ago

This will also enable HTML5 date selector support, if the browser supports it.

Hasib Tarafder · Accepted Answer · 2015-03-23 20:13:46Z

27

In mvc 4 you can easily do it like following using TextBoxFor..

@Html.TextBoxFor(m => m.StartDate, "{0:MM/dd/yyyy}", new { @class = "form-control default-date-picker" })

So, you don't need to use any data annotation in model or view model class

answered Mar 23, 2015 at 20:13

Hasib Tarafder

5,8133 gold badges33 silver badges44 bronze badges

1 Comment

bkwdesign Over a year ago

yup, those DataAnnotations work great for EditorFor helpers, but, when rendering a custom grid with an IEnumerable(Of Entity) you have to use the .TextBoxFor and this was my issue. Thanks

CodeArtist · Accepted Answer · 2015-10-09 19:14:56Z

23

If your data field is already a DateTime datatype, you don't need to use [DataType(DataType.Date)] for the annotation; just use:

[DisplayFormat(ApplyFormatInEditMode = true, DataFormatString = "{0:MM/dd/yyyy}")]

on the jQuery, use datepicker for you calendar

    $(document).ready(function () {
        $('#StartDate').datepicker();
    });

on your HTML, use EditorFor helper:

    @Html.EditorFor(model => model.StartDate)

edited Oct 9, 2015 at 19:14

CodeArtist

5,7068 gold badges46 silver badges66 bronze badges

answered Oct 7, 2015 at 16:59

Toddt

2592 silver badges5 bronze badges

2 Comments

MD TAREQ HASSAN Over a year ago

"If your data field is already a DateTime data type, you don't need to use [DataType(DataType.Date)]" => that was helpful

MD TAREQ HASSAN Over a year ago

But for web api, display format is not enforcing DataFormatString = "{0:MM/dd/yyyy}" (did not get any 400 even request body had other format i.e. {"dob":"31/12/1990"})

Chirag · Accepted Answer · 2014-03-22 12:02:07Z

19

Apply DataAnnotation like:

[DisplayFormat(DataFormatString = "{0:MMM dd, yyyy}")]

answered Mar 22, 2014 at 12:02

Chirag

4,1941 gold badge35 silver badges24 bronze badges

Comments

Renatto Machado · Accepted Answer · 2015-09-05 16:01:47Z

13

Use this, but it's a complete solution:

[DataType(DataType.Date)]
[DisplayFormat(ApplyFormatInEditMode = true, DataFormatString = "{0:dd/MM/yyyy}")]

answered Sep 5, 2015 at 16:01

Renatto Machado

1,5842 gold badges16 silver badges33 bronze badges

Comments

Philip Stratford · Accepted Answer · 2019-09-24 09:26:55Z

7

That works for me

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

edited Sep 24, 2019 at 9:26

Philip Stratford

4,8005 gold badges52 silver badges80 bronze badges

answered Jun 5, 2019 at 3:23

FelixAVeras

1,4341 gold badge12 silver badges18 bronze badges

1 Comment

Axel Samyn Over a year ago

The ApplyFormatInEditMode was the solution ! Thx

Md. Ilyas Hasan Mamun · Accepted Answer · 2015-04-11 10:33:54Z

5

After Commenting

          // [DataType(DataType.DateTime)]

Use the Data Annotation Attribute:

[DisplayFormat(ApplyFormatInEditMode = true, DataFormatString = "{0:dd/MM/yyyy}")]

STEP-7 of the following link may help you...

http://ilyasmamunbd.blogspot.com/2014/12/jquery-datepicker-in-aspnet-mvc-5.html

answered Apr 11, 2015 at 10:33

Md. Ilyas Hasan Mamun

1,8882 gold badges24 silver badges15 bronze badges

Comments

collusionbdbh · Accepted Answer · 2013-07-19 16:02:38Z

4

Use EditorFor rather than TextBoxFor

answered Jul 19, 2013 at 16:02

collusionbdbh

7001 gold badge6 silver badges18 bronze badges

Comments

Arkox · Accepted Answer · 2021-03-17 09:34:23Z

2

This is my favourite way to do that with anotations in your model:

[DisplayFormat(DataFormatString = "{0:dd/MM/yyy}")]

answered Mar 17, 2021 at 9:34

Arkox

712 bronze badges

Comments

user4719992 · Accepted Answer · 2015-07-31 07:51:36Z

0

set your property using below code at the time of model creation i think your problem will be solved..and the time are not appear in database.you dont need to add any annotation.

private DateTime? dob;
        public DateTime? DOB
        {
            get
            {
                if (dob != null)
                {
                    return dob.Value.Date;
                }
                else
                {
                    return null;
                }

            }
            set { dob = value; }
        }

answered Jul 31, 2015 at 7:51

user4719992

Collectives™ on Stack Overflow

Assign format of DateTime with data annotations?

11 Answers 11

7 Comments

1 Comment

1 Comment

2 Comments

Comments

Comments

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

11 Answers 11

7 Comments

1 Comment

1 Comment

2 Comments

Comments

Comments

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related