Error in inserting Date in the INSERT INTO statement

[gazelle04]

I'm trying to enter the current date into the table through code but there's an error in inserting the date.

Whats wrong with this code:

strSQL = "INSERT INTO University ([UniversityID], [BranchID], [DateOpened])"
strSQL = strSQL & "VALUES ( " & intUnivId & " , " & strBranchID & ", " & Date() & " );"

I don't know how to make the Date a string in order to run in the SQL statement.
Or should I leave it as it is without quotation marks.

[PEB]

Try the follow:

strSQL = "INSERT INTO University ([UniversityID], [BranchID], [DateOpened])"
strSQL = strSQL & "VALUES ( " & intUnivId & " , " & strBranchID & ", Now()" );"


or


strSQL = "INSERT INTO University ([UniversityID], [BranchID], [DateOpened])"
strSQL = strSQL & "VALUES ( " & intUnivId & " , " & strBranchID & ", Date()" );"


Have a nice luck!

[MMcCarthy]

You should also leave a space before the word VALUES:

strSQL = "INSERT INTO University ([UniversityID], [BranchID], [DateOpened])"
strSQL = strSQL & " VALUES ( " & intUnivId & " , " & strBranchID & ", Date()"

I'm trying to enter the current date into the table through code but there's an error in inserting the date.

Whats wrong with this code:

strSQL = "INSERT INTO University ([UniversityID], [BranchID], [DateOpened])"
strSQL = strSQL & "VALUES ( " & intUnivId & " , " & strBranchID & ", " & Date() & " );"

I don't know how to make the Date a string in order to run in the SQL statement.
Or should I leave it as it is without quotation marks.

[PEB]

And finally ;)

strSQL = "INSERT INTO University ([UniversityID], [BranchID], [DateOpened])"
strSQL = strSQL & " VALUES ( " & intUnivId & " , " & strBranchID & ", Date() );"