none
dateTimePicker value in VS 2005 & MS Access RRS feed

  • Question

  •  

    Hi,

     

    I have changed the regional setting in control panel to display date in dd/MM/yyyy format. I obtained the date in Date Time Picker as dd/MM/yyyy and insert into MS Access. It works fine if date is E.G. 16/10/2007. However, if it is, for E.G. 04/10/2007, the date changes to 10/04/2007 which is MM/dd/yyyy format.

     

    How do I solve the problem?

    Sunday, October 21, 2007 2:26 PM

All replies

  • I'm not sure how you are performing the INSERT but I believe that Microsoft Access expects a format of mm/dd/yyyy for dates. If the proper format is not supplied it will swap the month and day in order make certain that the date is valid.

     

    Monday, October 22, 2007 12:52 PM
  • I have the same problem, I always check the content to be in Date Format but I still have the same problem each time I pass the day less than 12 it converted it to month so if the date is 11/10/2007 (11-Oct-2007) it will pass it as 10-Nov-2007

    while it will pass 13/10/2007 it will pass it as 13-Oct-2007

     

    Please Help?

    Thursday, January 3, 2008 6:22 AM