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/
