Importing Non formatted date information

[mattc]

I am importing data from excel which includes a column containing dates. The problem is that the date is not formatted & is required for a letter template:

'260900' instead of 26/09/00

Is there any calculation i.e. texttodate( ) etc that would format the data correctly for me.

Cheers

Mattc

[Kurt Knippel]

quote:

---

Originally posted by mattc:

I am importing data from excel which includes a column containing dates. The problem is that the date is not formatted & is required for a letter template:

'260900' instead of 26/09/00

Is there any calculation i.e. texttodate( ) etc that would format the data correctly for me.

---

There is not a built in function which would let Filemaker determine what date this is supposed to represent.

You would need to build a calculation that takes the date as you get it from Excel and converts it into a formatted text field.

Simpler would be to have the data coming out of excel formatted as a date, so that Filemaker can simply read it as such.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=