My first ever post!! - although I often look here for solutions.

Can't find any help on this one:

I am trying to select all records from an orders table where the date is equal in part to an entered date. ie.

SELECT SUM (Order_Price) AS PRICE, SUM (Order_Quantity) AS QTY
FROM DayQuery
WHERE CourierID = passed4 AND Order_Category = '4' AND OrderDateTime LIKE passeddate%

User posts passeddate: '16/mar/04' or '16/03/2004'

My database has the date stored as '16/03/2004 10:29:01' and come back with no records.

I would like it to return all orders on that date irrespective of the time. I also don't really want to put the order time in a separate field. Any ideas ??

I have thought about using LIKE #16/03/04%# but the syntax is incorrect - am I opn the right tracks ??

Maybe this will help you out in some way...

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>

<%
date_string = "10-03-2004"
date_parts = Split(date_string, "-")

            day_part = date_parts(0)
            month_part = date_parts(1)
            year_part = date_parts(2)
    X = day_part & "/" & month_part & "/" & year_part
    response.write(X)

%>

Such is Life!

P.S...U could use " " as the value for the split as well if you want to split the date and time value and load it into a variable(If they seperated by a blank)

Maybe first write the date separately in a temp table and then run the query or loop through the recordset: split, check and if not equal to users input movenext, loop.

Hope this helps