JQuery Datepicker Will not post with UK date string

Question

Apologies for if the question is obvious but I can't figure out why it is suddenly not working. I have a jquery datepicker that has been working fine as long as I can remember, but all of a sudden, when I try to submit the form that the datepicker is on the datepicker reappears as though the date I am submitting is invalid. I have already set my date to uk style using the following line of code:

    <script type="text/javascript">
    $(document).ready(function () {
        $('.date').datepicker({ dateFormat: "dd/mm/yy", minDate: 0 });

    }); 
    </script>

And I setup the datepicker in my view like this:

@Html.TextBox("DateDue", "", new { @class = "date" })

I think that something is requiring the datestring selected to be in US format (as it will submit a valid us date (mm/dd/yyyy) but not the UK format, even though it has been set in the javascript.

Am I missing something obvious? Could anyone tell me what I'm doing wrong here?

Am not sure if it is necessary but the form that the datepicker is on is created like this:

@using (
    Html.BeginForm(
        Html.BeginForm(
            "Create",
            "Task",
            FormMethod.Post,
            new { id = "taskCreateForm" }
        )
    )
)

PS. The datestring actually works and posts without a problem in Firefox but not in Chrome

Any help appreciated

EDIT:

The problem goes away when I disable the unobtrusive js validation:

<script src="@Url.Content("~/Scripts/jquery.validate.unobtrusive.min.js")"
        type="text/javascript"></script>

I had a feeling it was something to do with this and tried remoing the [Required] and [DataType(DataType.Date)] from the model annotation but this didn't do the trick.

Not sure how to leave the unobtrusive js in as well as have the uk date string working ok, but am more and more turning to write my own javascript validation for forms than to even bother with the built in stuff, which never seems to work for anything more complicated than a 'required' validation check..

have you changed any of the javascripts on your page other then this? it could be an error somewhere else messing with it. — Patricia, Nov 15 '11 at 17:37
i did realise that I was declaring the default for the datepicker twice, thanks Patricia. But even with that fix the problem remained the same — DevDave, Nov 15 '11 at 17:41

Tessmore · Answer 1 · 2011-11-15T18:14:43.227

2

You can use the dateFormat, so in your javascript file (after the page is loaded etc.) you can place:

$('.datepicker').datepicker({dateFormat:'yy-mm-dd'});

edited Nov 15 '11 at 18:14

answered Nov 15 '11 at 16:29

Tessmore

1,054
1
9
23

did you mean $('.datepicker').datepicker({altFormat:'yy-mm-dd'});? Will give it a try, thanks – DevDave Nov 15 '11 at 16:44
Oh I will edit sorry, I meant what I typed in the code part :D – Tessmore Nov 15 '11 at 18:14

score 2 · Accepted Answer · edited May 23 '17 at 12:21

a google search gave a lot of results relating to localizing/globalizing asp.net mvc 3 validation.

this article in particular might be on to something:

http://www.hanselman.com/blog/GlobalizationInternationalizationAndLocalizationInASPNETMVC3JavaScriptAndJQueryPart1.aspx

scroll down to: "Globalized jQuery Unobtrusive Validation"

the answer to this question might help as well: Localizing jquery validation with asp.net mvc 3

jQuery allows you to override the different validation functions like so:

 $.validator.methods.number = function (value, element) {
     return !isNaN($.parseFloat(value));
 }

you could do something like this for the date validator, and run it against a regEx for a valid UK date.

This link provides some code that can be used to override the data parsing method: http://geekswithblogs.net/EltonStoneman/archive/2009/10/29/jquery-date-validation-in-chrome.aspx — daveywc, Jun 04 '12 at 12:21

AndyD · Answer 3 · 2011-11-15T15:59:24.537

1

Try using altFormat instead!

altFormat: "dd/mm/yy",

That works for me : )

EDIT: Try this on JSFiddle http://jsfiddle.net/adover/BRfcK/

edited Nov 15 '11 at 15:59

answered Nov 15 '11 at 15:21

AndyD

875
7
18

altFormat: "dd/mm/yy" is producing a date string in US format..?? it seems something is overiding my uk default but I can't figure out where... – DevDave Nov 15 '11 at 15:49

JQuery Datepicker Will not post with UK date string

3 Answers3

Linked