AnsweredAssumed Answered

Importing FMP date into SQL SERVER database

Question asked by tswalton@gmail.com on Apr 26, 2013
Latest reply on Apr 30, 2013 by philmodjunk

Title

Importing FMP date into SQL SERVER database

Post

     Hi,

     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

     Tim

Outcomes