Hi,
I'm using the Date Picker on a form and have it set up to use the format dd/mm/yyyy. When a user selects a date from the date picker (say 9th August 2006) then it appears in the text box as 09/08/2006 (which is correct), but then when that info is added to the database it changes to 08/09/2006 (i.e. 8th September 2006) which is wrong. If you select a date with the day greater than 12 (i.e. 14th) then it inserts the correct format into the database.
I've tried using the Dreamweaver date format but that didn't change anything (it just formatted the incorrect date found in the database). I've tried setting the LCID to 2057 (with Session.LCID=2057) but that didn't make any difference.
I've used the date picker before and never noticed it being wrong before. I have recently upgrade to Dreamweaver version 8.02 and I'm using version 1.3.9 of the Form Controls. I've also just started using a DSN Less connection to the database (don't know if that would make a difference or not).
Any ideas?
Thanks
Adrian. |
|
|