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.