This has probably been asked a hundred times but I could not find anything on the Exchange to fix my problem.
I built a query string for my SQL select statement that I simply want to show all records between two dates. (IE: 04/01/2009 - 04/10/2009)
The SQL table column "create_date" is a DATETIME type and I don't want the time to be a factor. I believe I need to change this statement to truncate the time off to make the between statement work.
"m_create_date1" and "m_create_date2" are vbscript variables I assign and fill from FORM field textfield that are 10 chars. So I need the time knocked off the SQL column field and some kind on function on these two vbscript variables to convert them to a DATE format that can work with the query.
query_string = "SELECT * FROM med_assist WHERE (med_assist.create_date BETWEEN " & m_create_date1 & " AND " & m_create_date2 & ")"