SET VAR vDateText = ('CSD1INVOICE_' + FORMAT(.#DATE,'MMDDYY') + '.DAT')
(set the date string order to what the receiving application requirements are. If I
had written the receiving app it would be 'YYYYMMDD', but we Canadians are always a
bit gun shy on date formats. Governmental formats are usually DDMMYY up here, but then
we have companies headquartered down there in the Excited States MMDDYY, etc.)
The least ambiguous I know of is NATO ddMMMyy - today is '05 Sep 02' - in strictly
number format you get 05/09/02 which is ambiguous.
Tirade over. You can rest easy now.
"randyp" <[EMAIL PROTECTED]> wrote:
>Dear David,
>
> � � � �SET DATE FORMAT MMDDYY
>
> � � � �SET VAR vDateText TEXT = (CTXT(.#Date))
>
> � � � �SET VAR vFileName TEXT = ('CSD1INVOICE_' +
>.vDateText)
>
> � � � �OUTPUT .vFileName
> � � � �[put your export here]
> � � � �OUTPUT SCREEN
>
> � � � �I hope this addresses the issues you are working on.
>
> � � � �Randy Peterson
>
>----- Original Message -----
>From: "David Ratliff" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Thursday, September 05, 2002 10:25 AM
>
>
>>
>>
>> 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/
>
--
Albert Berry
Full Time Consultant to
PSD Solutions
350 West Hubbard, Suite 210
Chicago, IL 60610
312-828-9253 Ext. 32
__________________________________________________________________
The NEW Netscape 7.0 browser is now available. Upgrade now!
http://channels.netscape.com/ns/browsers/download.jsp
Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.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/
