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 > > > > > >
