I run the following sql statement under US date format ("MM/DD/YYYY"). I
have no problem.
When switch to UK date format. I got problem. I suspect it is cause by Date
Format......Today.Date.ToShortDateString...
Please kindly advise if I am under UK date format, how should I solve the
problem.
Furthermore, there are UK and US users using my application, so how should I
solve the problem
myCommand1.CommandText = "INSERT INTO bm00ts0001 (tid, custno, tt,
salesrepcode, ddate) " & _
"VALUES ('" & Label1.Text & "','" &
Global.strCustNo & "','" & _
"2" & "','" & Global.strSalesRep &
"','" & _
Today.Date.ToShortDateString & "')"
myConnection.Open()
myCommand1.ExecuteNonQuery()
myConnection.Close()