AnsweredAssumed Answered

Convert Date Format When Importing from Excel

Question asked by slraymond on Dec 29, 2013
Latest reply on Dec 29, 2013 by keywords

I have a report that sorts by date. The data is imported from .xls. Unless I first edit the file so that the field is formatted mm/dd/yyyy, FM imports the date as yyyy-mm-dd, and the report fails to sort properly, grouping all items on the same day. Is there a way to convert the format as it is imported?

Outcomes