importing serial dates

[mattsmith]

Hi. Our business currently uses a legacy ADP system. Reports are hard to generate, and I'm testing out filemaker to see if we can generate reports more easily in an fm environment. However, the only type of file that the ADP will generate and that filemaker can read is a Lotus 123 CSV file. Which wouldn't be all that bad except that the dates are converted to excel serial dates. The rest of the data looks great. Is there any way to make filemaker convert the serial dates to standard gregorian format?

[comment]

Yes:

http://www.fmforums.com/forum/showtopic.php?tid/176851/post/206164/#206164