Alastair, Thanks for the potential heads-up. Alas, we are not using version 6.5++. WE are only at version 6.5+. We are saving our pennies to make the big leap to v7.0 and the windows version. Focus right now is getting ready for relocating from New Jersey to Louisiana later this year.
-- Jim Bentley American Celiac Society [EMAIL PROTECTED] - email (973) 325-8837 voice (973) 669-8808 Fax ---- "Alastair Burr" <[EMAIL PROTECTED]> wrote: > Jim, > > Have you actually tried FORMAT with TIME data types recently? > I mean with > the latest beta patch. > > Don't get too excited - I may be mistaken or imagining it - > I wasn't really > paying attention and I had it ear-marked as something to come > back to at a > later date but I think you may be surprised as it did seem to > work for me a > while ago. > > If I get a mo' I'll try and find what I was doing and check > it for you if > you're interested - please let me know - but I wanted to let > you know in > case you were missing an opportunity. > > Regards, > Alastair. > > > ----- Original Message ----- > From: "James (Jim) Bentley" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, September 06, 2002 8:35 PM > Subject: RE: > > > > David, > > > > supplimenting my previous post on this subject. You don't > need > > to futz with the date settings do it all in one step. > > > > SET VAR Filnam TEXT = (FORMAT(.#DATE,'CSD1INVOICE_MMDDYY.DAT')) > > out .filnam > > unl dat for buyers > > out scr > > > > This works regardless of your date format settings. You and > use > > any of the "SET DATE FORMAT" parameters MM, MMM, MMM+, DD, > YY, > > YYYY, CC, WWW, WWW+ , "/", "-", "," with the FORMAT function. > > > > This is an undocumented feature of the FORMAT function that > works > > with DATE data types. > > > > Alas there is no eqivalent items for #TIME or TIME data types. > > Perhaps an enhancement for v7.0. > > > > -- > > Jim Bentley > > American Celiac Society > > [EMAIL PROTECTED] - email > > (973) 325-8837 voice > > (973) 669-8808 Fax > > > > > > ---- "David Ratliff" <[EMAIL PROTECTED]> wrote: > > > Here is the syntax I used to test Claudine's solution: > > > set date mmddyy > > > set var cfafil text = 'csd1invoice_' > > > set var filnam text = (.cfafil+(ctxt(#date))+'.dat') > > > out .filnam > > > unl dat for buyers > > > out scr > > > This created a file from the BUYERS table with the name > > > CSD1INVOICE_090502.DAT > > > This is exactly what I needed! > > > > > > -----Original Message----- > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > > > Behalf Of J. Stephen Wills > > > Sent: Thursday, September 05, 2002 8:42 AM > > > To: [EMAIL PROTECTED] > > > Subject: Re: > > > > > > > > > > > > Shouldn't it be either CTXT(.#DATE) or &#DATE? > > > > > > Steve in Memphis > > > > > > ----- Original Message ----- > > > From: "Claudine Robbins" <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]> > > > Sent: Thursday, September 05, 2002 10:29 AM > > > Subject: RE: > > > > > > > > > > Sorry, I should've written: > > > > > > > > SET VAR var1 = "CSD1INVOICE_" > > > > SET VAR filename = (.var1 + #date + ".dat") > > > > OUT .filename > > > > > > > > Claudine :) > > > > > > > > > -----Original Message----- > > > > > From: [EMAIL PROTECTED] > > > > > [mailto:[EMAIL PROTECTED]] > > > > > Sent: Thursday, September 05, 2002 9:25 AM > > > > > To: [EMAIL PROTECTED] > > > > > Subject: > > > > > > > > > > > > > > > > > > > > To anyone out there?! > > > > > > > > > > I am working on an interface exporting data from RBASE > 6.1 > > > as an > > > > > ASCII delimited file to a 3rd party app. The 3rd party > app > > > requires the > > > > > filename contain an 18 character name with a 3 character > > > extension. > > > > > The 3rd party app requires I use the system date as > the > > > unique ID > > > > > for the last 6 characters of the filename. I can not > figure > > > out how to > > > > > precede my 6 character filename with the 12 additional > characters > > > > > (CSD1INVOICE_). > > > > > Once the job is complete I will have created an ASCII > delimited > > > file > > > > > using the name CSD1INVOICE_######.DAT where ###### is > the > > > current date > > > of > > > > > the export (unique ID) out of RBASE. > > > > > Any ideas how I might achieve a rename from short to > long > > > from RBASE > > > > > or DOS batch? I have tried XCOPY in a DOS batch file > but > > > that seems to > > > > > work only if I append the 12 additional characters. > Unfortunately > > > I need > > > > > them to precede the RBASE output filename. This is the > last > > > step in the > > > > > design and must be automated for the user. > > > > > > > > > > Thanks, > > > > > > > > > > David R. > > > > > Pine, Arizona > > > > > > > > > > ================================================ > > > TO SEE MESSAGE POSTING GUIDELINES: > > > Send a plain text email to [EMAIL PROTECTED] > > > In the message body, put just two words: INTRO rbase-l > > > ================================================ > > > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > > > In the message body, put just two words: UNSUBSCRIBE rbase-l > > > ================================================ > > > TO SEARCH ARCHIVES: > > > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > > > > > > > > ================================================ > > > TO SEE MESSAGE POSTING GUIDELINES: > > > Send a plain text email to [EMAIL PROTECTED] > > > In the message body, put just two words: INTRO rbase-l > > > ================================================ > > > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > > > In the message body, put just two words: UNSUBSCRIBE rbase-l > > > ================================================ > > > TO SEARCH ARCHIVES: > > > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > > > > ================================================ > > TO SEE MESSAGE POSTING GUIDELINES: > > Send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: INTRO rbase-l > > ================================================ > > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: UNSUBSCRIBE rbase-l > > ================================================ > > TO SEARCH ARCHIVES: > > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
