Erorr With Date Formats

[carlblanchard]

I have a problem

My Sql db is sat on a server which i guess is in U.S.A format cos dates are mm/dd/yyyy however im in england and the application is going to be used in england which is formatted like dd/mm/yyyy so in my code ive got this

Dim dteStartDate As Date = CDate(Format(Me.StartDate.Value, "MM/dd/yyyy"))
 
Dim Cmd As New SqlCommand("InsCalAppointment", MyConnection)
        With Cmd
            Try
                .CommandType = CommandType.StoredProcedure
.Parameters.Add("@dteStartDate", DbType.Date).Value = dteStartDate
.ExecuteNonQuery()
            Catch er As Exception
                MsgBox(er.ToString)
            End Try

An unhandled exception of type 'System.InvalidCastException' occurred in microsoft.visualbasic.dll

Additional information: Cast from string "12/16/2003" to type 'Date' is not valid.

Can any one help me plleaseeeee

[Grimfort]

Me.StartDate.Value

^ Is that actually a date variable coming back from that control (ie a date picker control) ? There is no point doing a cdate(format( as it cancels itself out, one formats to a string, the other converts to a date varaible. Try just using:

Dim dteStartDate As Date = Me.StartDate.Value

Because you are using parameters, it wont matter what format you send it, as long as its a datetype (date-types dont actually have formats, just a localized return value).

Heres how I have done mine, and it works fine: (yes its oledb)

 Dim NewItem As New OleDb.OleDbParameter("ParamName", OleDb.OleDbType.Date)
            NewItem.Value = ParamObject
            dbCommand.Parameters.Add(NewItem)

[carlblanchard]

Sorted its now done thanks