Entering the date into a sql script

[llaurit]

I am trying to take a date/time field from a database. This is the code that I have been using. I know everything works except for the date format. Please let me know what the correct format is. Thanks!

strAddNew = "INSERT INTO tblLog (Date, StartTime, EndTime, CustomerID, Employee, Category, Rate, BillableHours, Billed, Notes) "
strAddNew = strAddNew & "VALUES (#" & strDate & "#, '" & strStart & "', '" & strEnd & "', '" & strClient & "', '" & strEmployee & "', '" & strCategory & "', " & strBillRate & ", " & strBillHour & ", '" & strBilled & "', '" & strNote & "');"

 

[froggerIII]

try this:

strAddNew = "INSERT INTO tblLog (Date, StartTime, EndTime, CustomerID, Employee, Category, Rate, BillableHours, Billed, Notes) "
strAddNew = strAddNew & "VALUES (" & CDate(strDate) & ", '" & strStart & "', '" &
strEnd & "', '" & strClient & "', '" & strEmployee & "', '" & strCategory & "', " &
strBillRate & ", " & strBillHour & ", '" & strBilled & "', '" & strNote & "');"

 

[llaurit]

I tried using the CDate and I still got an error. Thank you anyway!!
Lynn

 

[froggerIII]

different databases (db2, SQL, access, etc...) require different date/time formats, you need to find out what format your database uses, and convert accordingly

 

[Guest_imported]

Try to convert date to string and not to date:
CStr(strDate)if you use SQL Server

 

[llaurit]

Ray, my problem was that I couldn't have "Date" as the field name in my db. Once I changed that the CDate and # format worked. Thanks!
Lynn