Insert query writing time to date field (1 Viewer)

[grahma_aiken]

Hi, first post - please be kind.

I have an insert query that looks like this:

DoCmd.RunSQL ("INSERT INTO DocTable ( FileID, DocType, DocTitle, DocStatus, DocSequence, DocCreationDate, DocCreationUser ) " & _
"SELECT " & intFileID & ", " & intDocType & ", " & Title & ", " & intStatus & ", " & intSequence & ", " & Date & ", " & intUser & ";")

Everything about this query works EXCEPT Date is not being written to the record - a time is and it isn't even the system time. I've used Date() a hundred times over in other queries and modules and haven't had this problem. Any ideas?

 

[pbaldy]

Try

"SELECT " & intFileID & ", " & intDocType & ", " & Title & ", " & intStatus & ", " & intSequence & ", #" & Date & "#, " & intUser & ";")

 

[grahma_aiken]

That worked. I cannot believe I didn't think of that. Thank you so much.

 

[pbaldy]

Happy to help, and welcome to the site!