Jump to content

Importing Date Formats


Anatoli
 Share

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

Recommended Posts

  • Newbies

Thanks for your help, but the information that I import, is in the form of "Wed Sep 05 21:18:40 2001". This needs to be changed to the desired format of "09/05/2001" but simply setting the format in the layout mode won't do.

I have heard some solutions that include some :'s in order to "pass up" certain information between the spaces and thereby importing only the date information.........Anybody?

Link to comment
Share on other sites

You'll have to import the date into a text field and then create a calculated field something like this:

cDate = TextToDate(

NumToText(Position("xxJanFebMarAprMayJunJulAugSepOctNovDec", Middle(rawdate, 5, 3), 1, 1)/3)&"/"&

Middle(rawdate,9,2)&"/"&

Right(rawdate,4)

)

[ September 07, 2001: Message edited by: BobWeaver ]

Link to comment
Share on other sites

  • Newbies

I do a daily download of web orders and they come through with an odd date format. I save the downloaded information as a text file, then import the info. to FM 5.0.

Can someone please tell me how I change "Wed Sep 05 21:18:40 2001" to

"09/05/2001"? I appreciate any assistance.

Link to comment
Share on other sites

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