Text to Date calc

[freecolours]

I can't figure this out! and hope that y'all have a solution for this...

I'm importing data from a .csv file into my FM database, so all the data is text formatted. Once I've done my importing, a date (date) shows the date as follows: 20010702. What I would like to have, is this text converted to a date format field and listed like this: 02-07-2001.

Is this possible?

[RussBaker]

This works... A calculation field with a date format result. This assumes the 02 on the right is the day, and the 07 is the month, and that days and months less than 10 will always have a leading zero.

=Date(

TextToNum(Middle(Text_IP, 5, 2))

,

TextToNum(Right(Text_IP,2))

,

TextToNum(Left(Text_IP,4))

)

[freecolours]

YES! This is it! Thanks a lot RussBaker!