Importing FMP date into SQL SERVER database
I have a date (creation date) in a field in FMP12. I want to get it into SQL Server.
In SQL Server I've created a table with a field of type datetime, and I've linked the table via ODBC to my fmp database.
So all I do is run an import script step that imports data from a fmp table into my SQL linked table.
This works fine with all fields except the date field, which comes through empty!
Can you help me to get the date field to transfer nicely from fmp to sql server please?
Many thanks in advance