I want to import a Foxpro Database to Access with Date Field. I'm importing the data through VB Code by assigning two diff. recordsets for (One for Old Foxpro Table and One for Access DB). I've written the code as follows to import the date field.
newrecordset!DueDate = OldRecordSet!DueDate
In this case, the data imported successfully, but the data imported is not correct (only for the dates upto 12, other dates imported correctly). Date & Month are interchanged. For example, if I want to import the date 06-10-2018 (dd-MM-yyyy) from Foxpro table to Access, the date is stored as 10-06-2018 in Access Database. Hence, I changed the code as follows:-
newrecordset!DueDate = format(OldRecordSet!DueDate, "MM-dd-yyyy")
Even this code also imported the Date Field as 10-06-2018 instead of 06-10-2018 (correct one).
Please help me how to import the date field from a Foxpro Table to Access Table.