Reformat Date Field from .CSV import

[Kevin Kokesh]

Hi, I'm a complete beginner in FMP. (Sorry if this is the wrong forum)

I am using a web database (baseportal) simply because it has a simple interface for mobile access and I will be regularly importing the records from this into FMP. The date field, though, is ugly. Baseportal exports the date as: "YYYY.MM.DD,00:00.00#n#-06:00"

with n being a number 1-9 (I'm not sure what it is yet, I think it might be dependent on the hour of the day I create the record.) Everything after the DD is constant; it is always 00:00.00...

Anyway, I would like the date to be in the form MM/DD/YYYY or at the very least, YYYY.MM.DD as it appears in the original. In other words, I'd like to get rid of the other stuff.

I tried searching for how to do this but I can't find how to change it from YYYY.MM.DD to MM/DD/YYYY. Anyone?

Thanks!

[comment]

Try importing the date data into a Text field, and have a real Date field auto-enter a calculation =

Date (

Middle ( Imported ; 6 ; 2 ) ;

Middle ( Imported ; 9 ; 2 ) ;

Left ( Imported ; 4 )

)

[Kevin Kokesh]

thanks so much, it worked like a charm!