Date Inserted as 30-Dec-1899 (1 Viewer)

[Lissa]

I'm kinda stumped right now..

After the user updates a subform, it inserts a record into another table.
The transaction date, which is the OrderDate from a parent form, keeps getting inserted into the table as 30-Dec-1899... how can I fix that?


Dim strSQL As String
strSQL = "INSERT INTO PART_STATUS (SerialNumber,TransactionDate, StatusId, PartInvId) VALUES ('888888', " & Forms![frmPurchaseOrder]![OrderDate] & ", '1', " & PartInvId & ")"
DoCmd.RunSQL strSQL

Thanks!

 

[boblarson]

Change this part:
VALUES ('888888', " & Forms![frmPurchaseOrder]![OrderDate] & ", '1', " &

To this:

VALUES ('888888', #" & Forms![frmPurchaseOrder]![OrderDate] & "#, '1', " &

 

[Lissa]

Awesome! That did the trick - Thanks!!!

 

[boblarson]

Glad we could help