Converting Dates

[Commcare]

I am importing (Via OBDC) information into Filemaker from a legacy pharmacy system. The pharmacy software stores a date as YEAR__DAY_OF_YEAR i.e. 2002001 for January 1, 2002. I am having extreme difficulty converting 2002001 to 01/01/2002 with a calculation.

Any Suggestions?

[email protected]

[rdhaden]

Assuming the field you are converting from is type text and always consists of 7 digits,

Date(1, 1, Left(DateField, 4)) + TextToNum(Right(DateField, 3)) - 1

[Commcare]

Thanks! Worked great...Actually it was pretty simple...It's amazing how sometimes your brain just refuses to cooperate with your eyes....