0

I am using Jquery date picker, problem i am facing now is that the date format on the database is dd/MM/YYYY , while the date format for the date picker it is MM/dd/YYYY, so how i can manage to change the calender date format to be consistent with the databse? i tried this but it did not work:-

$(":input[data-datepicker]").datepicker();
    $("this").datepicker({ dateFormat: 'dd-mm-yy' });
johnjohn123
  • 1
  • 1

3 Answers3

1

Just as a general note, I would recommend not relying on a single date format for the UI and the database, as users can have different preference on how to enter dates, depending on where they live. So, parse the incoming date into a Date object, and store it as a Date object in the database, is my recommendation.

However, to change the date format on the datepicker, see the following StackOverflow thread:

jQuery UI DatePicker - Change Date Format

Community
  • 1
  • 1
Erik A. Brandstadmoen
  • 10,159
  • 2
  • 35
  • 54
  • thanks for ur reply, but in the database there is one specific format for the date (i am using SQL server). this date format is dd/MM/YYYY. and i think that all the incomming date should be formatted in this way . currently my datepicker whould display any selected date as MM/dd/2011. so if i select from the date picker 20 August 2011, the ystem will display a message that the date format is wrong (since there is no month 20 )!! – johnjohn123 Aug 06 '11 at 12:45
  • 1
    I don't understand. Are you saying that you store the date in the database as a string? Why don't you use the DateTime (or, if on SQL server 2008+, Date) types? Then the format shouldn't matter. The date is stored in binary format, not as a string (http://msdn.microsoft.com/en-us/library/ms187819(v=SQL.90).aspx). – Erik A. Brandstadmoen Aug 07 '11 at 12:30
0

hi something like this.

Put this at the top of your of your scripts.

$.datepicker.setDefaults($.datepicker.regional['<%=System.Threading.Thread.CurrentThread.CurrentUICulture.TwoLetterISOLanguageName %>']);

This you are free to use them as normal.

$("#TxtStartDate, #TxtEndDate").datepicker({
});
iain
  • 1,530
  • 11
  • 18
0

i tried this and it worked well $(":input[data-datepicker]").datepicker({ dateFormat: "dd/mm/yy" }); BR

johnjohn123
  • 1