I receive a txt file with date information formatted as: 20040726 (no delimiters)
Is there a magic (read: straightforward calculation) way in FMP7 to convert this to a date formatted as 7/26/2004?
Just thought I'd ask before I go "old school" and create too many extra fields to extract, sort and re-combine the info.
I've been off FMP for a while and on Excel far too long.