Date Magic

[Rex Havoc]

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.

[QuinTech]

Hi, Rex. Make a calc date field with the calc:

Case( 



  not IsEmpty( TextDate ) , 

   Date( 

     Middle( 

       TextDate , 

       5 , 

       2 

     ) , 

     Right( 

       TextDate , 

       2 

     ) , 

     Left( 

       TextDate , 

       4 

     ) 

   ) 



)

HTH,

Jerry