RE: Witango-Talk: Date Issue

[Vicky Bagwalla]

Title: RE: Witango-Talk: IE browser share now 93% in 2002 (Off topic news)

Through Tango, I am passing the date as %d-%b-%Y (Evaluates to 14-Jun-2002) into a column “datetime” in the database. Now the SQL user for this database (DSN on dev and deployment is set to BRITISH ENGLISH). All is ok and the value inserted in the database is 14/06/2002.   PROBLEM : If the “day” part of the date is < 12 then the database flips month and day around . Example : 10-Jun-2002  . SHOULD be stored as : 10/06/2002   but is stored as 06/10/2002.   Really really need help with this silly thing.   Note : I can then go into SQL directly and enter date as 10/06/2002 no problem. Only through Tango !!!   You may contact me off the list too at : [EMAIL PROTECTED]   Thanks !   - Vicky