Anatoli Posted September 7, 2001 Posted September 7, 2001 You can set format of date field on layout.
Newbies thebass Posted September 7, 2001 Newbies 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?
BobWeaver Posted September 7, 2001 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 ]
Newbies thebass Posted September 8, 2001 Newbies 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.
Recommended Posts
This topic is 8478 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