AnsweredAssumed Answered

SQL CSV export into FMP - Date/Time Calc

Question asked by ibgarrett on Mar 2, 2011
Latest reply on Mar 2, 2011 by philmodjunk


SQL CSV export into FMP - Date/Time Calc


I'm working on a FMP database where I'll be regularly picking up a CSV dump out of a MSSQL database.  I'd like to preserve the Date/Time fields if possible.  I tried importing the raw CSV data into FMP and the string of the text field (which was a date field) comes out like "1230131835"  Any suggestions or pointers as to how to interpret the data showing up?  I tried (wishfully thinking I know) just changing the text field to a date field, but that didn't work...

TIA for any help.