Marc, Sometimes the error message that you get doesn't really tell you what the problem is. I do manipulations like that all the time, and usually get that message 2 or 3 times before I finally get it right! Sometimes, the parens are not balanced, or you will be missing a comma or single quote, etc.
Just in case you didn't know, if you're testing an application and get an error message for a missing ENDI, ENDSW, etc., and you find that all your ifs and endifs etc match up, the problem is usually a missing paren or quote. You can do a search & replace to determine how many left parens, right parens, quotes, etc to see where your problem is!!! Jan ----- Original Message ----- From: "Jan Barley" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Thursday, March 03, 2005 11:19 AM Subject: [RBG7-L] - RE: Date format 02 23 05 > Marc, > Your parentheses are not balanced. Add one more to the end and it should > work fine. > > Jan Barley > > ----- Original Message ----- > From: "Marc" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[email protected]> > Sent: Thursday, March 03, 2005 11:05 AM > Subject: [RBG7-L] - RE: Date format 02 23 05 > > > > What I really want to do is > > but this is over my head. > > > > Vtrdate = (IFEQ(Insnumber,123,(CTXT(FORMAT(Tr_date,'mmddyy'))), > > (CTXT(FORMAT(Tr_date,'mm/dd/yy'))) ) > > > > but I get an error about a constant can't be > > followed by a left parentheses > > > > > > Marc > > > > > > > > > > ----- Original Message ----- > > From: "Marc" <[EMAIL PROTECTED]> > > To: "RBG7-L Mailing List" <[email protected]> > > Sent: Thursday, March 03, 2005 9:49 AM > > Subject: [RBG7-L] - RE: Date format 02 23 05 > > > > > > > Larry > > > > > > If I use that and set the var to text I > > > get a syntax error > > > > > > If I set the var to date I get > > > the error about not having the same > > > type and scale. > > > > > > This should be so easy? What's wrong? > > > > > > Thanks > > > Marc > > > > > > > > > ----- Original Message ----- > > > From: "Lawrence Lustig" <[EMAIL PROTECTED]> > > > To: "RBG7-L Mailing List" <[email protected]> > > > Sent: Thursday, March 03, 2005 9:34 AM > > > Subject: [RBG7-L] - RE: Date format 02 23 05 > > > > > > > > > > > rTextDate = (CTXT(FORMAT(Tr_date,'mmddyy'))) > > > > > > > > FORMAT returns a variable of type TEXT, so use: > > > > > > > > rTextDate = (FORMAT(Tr_date,'mmddyy')) > > > > > > > > -- > > > > Larry > > > > > > > > > > > > > > > > > > > >
