Importing Date Formats

[Anatoli]

You can set format of date field on layout.

[thebass]

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?

[BobWeaver]

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 ]

[thebass]

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.