Date format in asp.net MVC

Question

I have created a simple application build using asp.net MVC and SQL Server targeting the azure platform. My question is around date formatting. I have added a date picker which correctly uses dd/mm/yyy format. however when I pick the date I get the following validation error.

enter image description here

The project was build using database first. here is a screenshot of the property for that data item:

enter image description here

Where do I change the validation to accept dd/MM/yyyy. Also is there a way to set it so if there is a user in the US it will change date picker and validation to MM/dd/yyyy?

in both situations the date will be saved to the database as standard yyyy-MM-dd hh:mm:ss

You haven't even told us which date picker plugin your using. Perhaps you could check its documentation — user3559349
– user3559349, Commented Oct 22, 2014 at 2:45
the problem is not dependent on the picker as it was happening when it was just a text field however in this case its Kendo UI — Spionred
– Spionred, Commented Oct 22, 2014 at 3:36

Steve Wellens · Accepted Answer · 2014-10-22 01:26:14Z

6

Burn this into your brain:

mm is minutes.

MM is months.

answered Oct 22, 2014 at 1:26

Steve Wellens

20.6k2 gold badges31 silver badges70 bronze badges

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

Comments

Hemant B · Accepted Answer · 2014-10-22 09:20:07Z

0

The issue is clearly with your date format. You are entering dates in the format of dd/MM/yyyy while the system is expecting MM/dd/yyyy.

Please check in your model whether you have specified any specific date formats.
Change the Ui culture of Kendo

Like this

    <script>
         //set current to the "en-GB" culture script
         kendo.culture("en-GB");
    </script>

answered Oct 22, 2014 at 9:20

Hemant B

1401 silver badge9 bronze badges

Collectives™ on Stack Overflow

Date format in asp.net MVC

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