Mike There are a couple of things to try. 1.> Set date format mmddyyyy SET VAR VFNM TEXT = ((CTXT(.VSTDT))+'-'+(CTXT(.VTHRDT))+'.XLS')) set date format mm/dd/yyyy Plus you needed and extra ) at the end of the first ctxt command and had an extra ) at the end. 2.> If you are running 7.6 or 8.0 try the format command like this; set v VFNM = ((FORMAT(.VSTDT,'MMDDYYYY'))+'-'+(FORMAT(.VTHRDT,'MMDDYYYY'))+'.XLS'))
I find FILENAME .VFNM works just fine. Hope this helps. Bill Eyring _____ From: [email protected] [mailto:[email protected]] On Behalf Of mike epstein sony viao office Sent: Saturday, October 03, 2009 9:50 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: DYNAMIC FILENAME FOR XLSPREADSHEET Dawn I had tried the ampersand and couldn't get the value 09242009-09302009.xls ? From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Saturday, October 03, 2009 8:34 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: DYNAMIC FILENAME FOR XLSPREADSHEET SET VAR VFNM TEXT = ((CTXT(.VSTDT)+'-'+(CTXT(.VTHRDT)+'.XLS'))) PRINT EMPPYSM2V2s1a WHERE enddate >= .VSTDT and enddate <= .VTHRDT + OPTION XLS + |FILENAME &vfnm + |SHOW_CANCEL_DIALOG OFF + |ALL_TEXT_IN_GENERAL_FORMAT off + |CELL_ATTR On + |INCLUDE_IMAGES OFF + |INCLUDE_LINES OFF + |INCLUDE_RICH_TEXT On + |RICHTEXT_ENCODING_TYPE IMAGE + |INCLUDE_SHAPES OFF + |LINE_SPACE ACTUAL + |ONE_SHEET_PER_PAGE ON + |OPEN ON Dawn Hast [email protected] wrote on 10/03/2009 09:26:01 AM: > Good Morning all > > > Having a blurb and maybe some on can help. > > SET VAR VFNM TEXT = ((CTXT(.VSTDT)+'-'+(CTXT(.VTHRDT)+'.XLS'))) > I would like a variable to be the filename using two dates > > PRINT EMPPYSM2V2s1a WHERE enddate >= .VSTDT and enddate <= .VTHRDT + > OPTION XLS + > |FILENAME NEW.XLS + How would I express the variable here? > |SHOW_CANCEL_DIALOG OFF + > |ALL_TEXT_IN_GENERAL_FORMAT off + > |CELL_ATTR On + > |INCLUDE_IMAGES OFF + > |INCLUDE_LINES OFF + > |INCLUDE_RICH_TEXT On + > |RICHTEXT_ENCODING_TYPE IMAGE + > |INCLUDE_SHAPES OFF + > |LINE_SPACE ACTUAL + > |ONE_SHEET_PER_PAGE ON + > |OPEN ON > > > Thanks > > > Mike DISCLAIMER: This electronic message together with any attachments is confidential. If you are not the intended recipient, do not copy, disclose or use the contents in any way. Please also advise us by return e-mail that you have received the message and then please destroy. Evergreen Packaging is not responsible for any changes made to this message and / or any attachments after sending by Evergreen Packaging. We use virus scanning software but exclude all liability for viruses or anything similar in this email or any attachment.
