Jump to content
Sign in to follow this  
Justin Brandt

importing dates with different formats

Recommended Posts

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

Share this post


Link to post
Share on other sites

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).

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  

  • Who Viewed the Topic

    1 member has viewed this topic:
    doughemi 
×

Important Information

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