A problem when importing dates

[Dave E]

I'm importing data from a text file and parsing it (using the "middle" function). One of the data elements is a date (needed for subsequent calculations), but FM seems to read it as a number and converts that number to a date, which is not the date originally imported.

How can I resolve this? I searched previous threads, but couldn't find anything similar.

Thanks

Dave

[Lee Smith]

You are probably going to have to use some text and date functions depending on how the import looks. Try this one and if it doesn't work, let me know what format it is in (i.e. is it 1/1/02, or 01/01/2002, or Jan 1, 2002, etc.)

Date(LeftWords(Text Date, 1), MiddleWords(Text Date, 2, 1), MiddleWords(Text Date, 3, 1))

HTH

Lee

[Dave E]

Thanks...that does the trick.

And I'm embarrassed that I asked the question... I should have remembered that!

Dave