I have a string which is a timestamp but when I pass it to my sql query, i get the below error.

Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type varchar to datetime.

/reports/lornasReport.asp, line 76

Could anywayone tell me why this is please

you provided some data that wouldn't convert

but without seeing what you sent and how would be anyones guess at why.

Hi there.

This is the code i am using to create a parameter and pass.

startDate=replace(startDate, "-","")+"000000"
endDate=replace(endDate, "-","")+"235959"
timeStamp1 = startdate
timeStamp2 = endDate

'ParamString = SQLFormatOut(timeStamp1, datetime, True) & ", " & _
' SQLFormatOut(timeStamp2, datetime, True)

Set oRS = oConn.Execute("EXEC getLornasReport " ) '& ParamString

Without knowing how startdate & enddate are delivered to the script and what the SP does it's impossible to say, you'll have to do the basic debugging.
You need to response.write out variables and values to ensure that you are getting and passing what values you expect.

You obviously have the paramstring creation and passsing commented out so how does the SP get the data?

Startdate and endDate are simply created by
Dim startDate, endDate

Any more help would be appreciated.

Dim startDate, endDate ,allTotalWrap

dim timeStamp1
dim timeStamp2

if request.form("act")="go" then

startDate=request.form("date1")
endDate=request.form("date2")
startDate=replace(startDate, "-","")+"000000"
endDate=replace(endDate, "-","")+"235959"
timeStamp1 = startdate
timeStamp2 = endDate

allOrders = getAllOrders()

end if

startDate=replace(startDate, "-","")+"000000"

What exactly is the point of this? Adding multiple zeros to this will essentially do nothing.

If you are receiving a string as your date I would suggest keeping it type specific. So, you need to use a date object, to be sure the format will be correct.

dim startDate = request.form("date1")
dim endDate = request.form("date2")

startDate = CDate(startDate)
endDate = CDate(endDate)

This will either convert your string into a valid date object or throw an error.

(Keep in mind I'm not as familiar with ASP.OLD as I am with ASP.NET so please bear with my examples if they are a little off)

I can see lots that can go badly wrong with the code. Especially this

startDate=request.form("date1")
endDate=request.form("date2")

You are expecting dd-mm-yy by the look of it, what happens when someone enters 21/11/05 or 21st Nov 2005 or any combination of the dozens of ways dates can be entered.

As cptnwinky says you will have to do some typecasting to get the data in the correct format.