Jump to content
Sign in to follow this  
pehrlabel

Converting Non USA Dates?

Recommended Posts

When I import records from a distributor, if the country field is not USA, the days and months are reversed in the date fields.

Instead of mm/dd/yyyy

I get dd.mm.yyyy

I have two sets of date fields for every record I import, a start date and a closing date. And the non USA dates are made with periods instead of slashes.

can I set a script or something so that if it says USA in one field, it doesn’t change the two date fields? but if it does NOT say USA in that field, it switches the dd.mm.yyyy to mm/dd/yyyy in both of the date fields for that record?

right now i'm just looking them up and doing a batch replace, but i bet there might be a way to do it when I'm importing the records.

Thanks! Adam

Edited by Guest

Share this post


Link to post
Share on other sites

I think it would require a seperate text field for the import. It would definately require that the data you are importing is consistent. FM7 example attached that uses import fields and auto-enter calculations.

Dates.zip

Share this post


Link to post
Share on other sites

It worked exactly perfect. I tested it alone, and now i'm going to bring those calculation fields you made into my database.

Luckily the information I get is very consistent. A robot from the distributor sends the information, so humans like me won't be able to make typos.

Sorry I take a while to reply after you nice people offer your help. I just go out of town a lot, and i don't take filemaker on the road with me.

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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