importing dates with different formats

[Justin Brandt]

I am importing a date field to FMP7 from excel with the format 19950401 (for April 1, 1995). Is there a calculation that can convert this format to, say, 01-Apr-1995, or any other of the pre-set date formats?

Thank you in adavnce,

Justin

[-Queue-]

Import to a text field, then loop or run a Replace on your found set to set your date field with

Date( Middle( textfield; 5; 2 ); Right( textfield; 2 ); Left( textfield; 4 ) )

You can then format your date field on a layout using any of the available options under Format -> Date (in Layout Mode).