Date in SQL String has Wrong Syntax

[Steve Dyke]

I am using the jquery datepicker to drive a request to gather data using a remote data sql call.

I get an error on some computers that the date syntax is wrong(03-17-2017).

I the javascript of my application index file I have this code:

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

I do not understand how the date format is changing on its way to the remote call code.

[Jeanne Boyarsky]

Steve,
Is 03-17-2017 the desired syntax or what is getting passed to the database? Also, is jQuery the last time your application has control of the data? Or does it go to something on your server first?

[Steve Dyke]

Jeanne Boyarsky wrote:Steve,
Is 03-17-2017 the desired syntax or what is getting passed to the database? Also, is jQuery the last time your application has control of the data? Or does it go to something on your server first?

My desired format is 03/17/2017.

I did find another javascript code that was formatting datepicker with dash style dates. I think this is the reason I am having issues.

Thanks for your help.