Jquery datepicker taking US date format for validation

Question

I am getting validation message on chrome if i select date >12

I have used localised datepicker with syntax

var abc = $("#culture").val();
        $.datepicker.setDefaults($.datepicker.regional[""]);

        $("#dob").datepicker({
            changeMonth: true,
            changeYear: true,
            dateFormat: 'dd-mm-yy',
            yearRange: '-90:-15',
            defaultDate: '-90y'

        });
        $.datepicker.setDefaults($.datepicker.regional[abc]);

another problem : I am getting date in undesirable format at controller, that is why my database holds wrong entry(date in place of month and month in place of date)..suggest me the possible solution...

What relevant i found is LINK 1

Link2

Link 3

But none of the above works...

score 0 · Answer 1 · edited Sep 15 '17 at 14:47

Try this:

$("#dob").datepicker({
    changeMonth: true,
    changeYear: true,
    dateFormat: 'mm-dd-yy',
    yearRange: '-90:-15',
    defaultDate: '-90y'
});  

var abc = $("#culture").val();  

$("#dob").datepicker("setDate", new Date(abc));

$("#dob").datepicker({
    changeMonth: true,
    changeYear:  true,
    dateFormat:  'dd-mm-yy',
    yearRange:   '-90:-15',
    defaultDate: '-90y'
});

Otherwise you can get the date as a sting and then converted in to your required format.

If you're running with jQuery you can use the datepicker UI library's parseDate function to convert your string to a date:

var d = $.datepicker.parseDate("DD, MM dd, yy",  "Sunday, February 28, 2010");

And then follow it up with the formatDate method to get it to the string format you want:

var datestrInNewFormat = $.datepicker.formatDate( "mm/dd/yy", d);

If you're not running with jQuery of course it's probably not the best plan given you'd need jQuery core as well as the datepicker UI module... best to go with the suggestion from Segfault above to use date.js.

score 0 · Answer 2 · answered May 30 '12 at 13:18

First of all, if you are using MVC, and you show some date from the server, you should display the date like:

@Html.TextBox("InsertDate", Model.InsertDate.ToString("dd/MM/yyyy"), new { @class = "date" })

And in your jquery just :

$('.date').datepicker({ dateFormat: "dd/mm/yy" }).val();

The ModelState.IsValid will break if your culture is en-US. A dirty hack for this is something like this:

var insertDateStr = ModelState.Values.ToList()[3].Value.AttemptedValue;
var insertDate = DateTime.ParseExact(insertDateStr, "dd/MM/yyyy", CultureInfo.InvariantCulture, DateTimeStyles.None);

And finally for the red on chrome just add background color white in the style of textbox.

@Html.TextBox("InsertDate", Model.InsertDate.ToString("dd/MM/yyyy"), new { @class = "date", @style = "background-color: white;" })

It is very dirty but it works..

score 0 · Answer 3 · edited May 23 '17 at 11:56

0

The solution is not so simple, you should end up overriding the jquery validation rule. I recommend using the Globalize plugin as described in here MVC 3 jQuery Validation/globalizing of number/decimal field

edited May 23 '17 at 11:56

Community

1
1

answered Jun 26 '13 at 13:54

alexb

971
6
12

score 0 · Answer 4 · answered Sep 15 '17 at 18:48

0

Use <globalization culture="en-GB"/> in web.config if you expect ASP.Net to acknowledge date in "dd-MM-yyyy" format.

reference

answered Sep 15 '17 at 18:48

shakib

5,449
2
30
39

Jquery datepicker taking US date format for validation

4 Answers4