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/
