oops, I meant to do: use (FORMAT(.#DATE,'MMDDYY'))
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Dennis McGrath Sent: Saturday, January 25, 2003 9:42 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: What it the correct syntax use (FORMAT(.#DATE,'MM/DD/YY')) also it is usually good practice to start a filename or directory name with a letter Dennis McGrath -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of David Billing Sent: Friday, January 24, 2003 3:27 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: What it the correct syntaxx Hi Charles, I think you're going to have to parse the string produced by (ctxt(.#date)) to strip out the "/" which won't work in a file name. So you want something like: SET VAR vNewDir TEXT = (CTXT(.#DATE)) SET VAR vNewDir = (SGET(vNewDir,2,1)) + (SGET(vNewDir,2,4)) + (SGET(vNewDir,4,7)) SET VAR vNewDir = ('g:\' + .vNewDir + (CTXT(.vCount))) You may want to pad .vCount with leading zeros or reverse the SGET order to put the year first, month second, etc. Dave Billing Tall Tree Business Solutions ----- Original Message ----- From: "Charles Parks" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Friday, January 24, 2003 3:56 PM Subject: [RBASE-L] - What it the correct syntaxx > > What would be the correct way to write this statement: > SET VAR vNewDirectory TEXT = ('g:\' + (ctxt(.#date)) + '\' + > (ctxt(.vCount)))? > > I have verified that .vCount does have a value but Rbase says this command > cannot be evaluated. >
