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,
The source table (recordset2) has dates entered as text.
Thanks for the help.
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,
Code:
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.