esthera
11-05-2007, 02:54 AM
I have a asp script that updates an access db on a uk server (date format is - dd/mm/yy)
now when i have an sql that puts in
update customers set sent=#11/10/2007# where ticketid='3245820'
it goes into the db as 10/11/2007
it's not happening with dates such as 16/10/2007 which are going in correctly?
any ideas?
now when i have an sql that puts in
update customers set sent=#11/10/2007# where ticketid='3245820'
it goes into the db as 10/11/2007
it's not happening with dates such as 16/10/2007 which are going in correctly?
any ideas?