Jump to content

Importing Non formatted date information


mattc
 Share

This topic is 7689 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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

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

Link to comment
Share on other sites

This topic is 7689 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.