Jump to content

Convert different date formats to consistent format


Lotec
 Share

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

Recommended Posts

  • Newbies

I'm using FileMaker Pro Ver 8 on a Macintosh, and importing files into a table. I am importing three different files, using the Update on Key ID on files 2 and 3.

Each file has the date in a different format. Each date gets imported into a FM Pro Date field. So I end up with 3 different dates in each record.

FM Pro recognizes all three formats just fine. THey are

6/1/2006

June 1, 2006

2006-06-01

I would like to push a button in FM Pro and convert the fields to a consistent format. Say 2006-06-01.

Can anybody point me in the right direction.

Thanks

mark

Link to comment
Share on other sites

Are these text files that you are importing?

If so, I would change the dates prior to import using a text editor. If you don't have BBEdit, or TextWrangler, you can download a Free copy of TextWrangler from

http://www.barebones.com/

I use TextWrangler Grep Pattern Find and Replace for this type of file manipulation all of the time. If you need help with the Grep patterns, let me know.

BTW, the format 2006-06-01 is NOT a proper Date format, although you can have it display that way once it is entered.

HTH

Lee

Edited by Guest
Link to comment
Share on other sites

This topic is 5656 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.