Access VBA - Date as text converts to a math division when copied

[icyrius]

Hello experts,

I have a text date (7/1/2015) that when copied to another table converts as a math division and pastes an integer (3.47394540942928E-03). The receiving table has been formatted to be also a text field.

This the part of the code where is pasting the record set,

DoCmd.SetWarnings False
DoCmd.RunSQL "INSERT INTO tbl_DatesbyLocation (Location,Start_Date,End_Date) VALUES (" & recordset1.Fields(0).Value & "," & recordset2.Fields(0).Value & "," & recordset2.Fields(1).Value & ")"
recordset1.MoveNext

The source table (recordset2) has dates entered as text.

Thanks for the help.

 

[xenou]

ON the general principle that string data needs to be enclosed in quotes, I would try:
"'" & recordset2.Fields(1).Value & "'"

Remember that you are creating a raw SQL string here, which is simply run as such.