Anatoli Posted September 7, 2001 Share Posted September 7, 2001 You can set format of date field on layout. Link to comment Share on other sites More sharing options...
Newbies thebass Posted September 7, 2001 Newbies Share Posted September 7, 2001 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 More sharing options...
BobWeaver Posted September 7, 2001 Share Posted September 7, 2001 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 More sharing options...
Newbies thebass Posted September 8, 2001 Newbies Share Posted September 8, 2001 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 More sharing options...
Recommended Posts
This topic is 8052 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 accountSign in
Already have an account? Sign in here.
Sign In Now