Hi there

I've got a calendar field that outputs a date like: 28/01/2011 - I need to convert that to 28012011 before inserting it into my sql server field - how can I strip out the / separators?

thanks

Adam

As an addition to this I've made some progress but am stuck with the error: Error converting data type int to datetime.

My sql is this:

strSQL = "EXEC sp_date " & _
"" & strDate & ", " & _
"'" & Replace(Request("txtVenue"), "'", "''") & "', " & _
"'" & Replace(Request("txtLocation"), "'", "''") & "', " & _
"'" & Replace(Request("txtWebsite"), "'", "''") & "', " & _
"'" & Replace(Request("txtBookOnline"), "'", "''") & "'"

I'm struggling to work out why it's throwing this error:

The format it is getting the date in is

26012011 and the sql field type is datetime

thanks

Adam