Marc ???? Just for kicks, exit out and go back in and try it again. I remember once having a problem like that and it seemed to be because the first time I defined the variable, I used the wrong type and it seemed to be stuck in there somewhere.
Dawn -----Original Message----- From: Marc [mailto:[EMAIL PROTECTED] Sent: Thursday, March 03, 2005 11:27 AM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Date format 02 23 05 Dawn This is my code, looks the same as yours but mine still gets those errors....why could that be? I really appreciate everyone trying to help me on this problem. xvtstdate = (ifeq(insco1,1,(format(tr_date, 'mmddyy')), (format(tr_date,'mm/dd/yy')))) vtstdate = (ifeq(jonum,37000,(format(odate, 'mmddyy')), (format(odate,'mm/dd/yy')))) -- I addes the x in front of my var to make sure it was not defined before Marc No CTXT. When the report prints with jonum 37000, I get 120104. When I print it with 37001, I get 12/01/04. -----Original Message----- From: Marc [mailto:[EMAIL PROTECTED] Sent: Thursday, March 03, 2005 11:06 AM To: RBG7-L Mailing List 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 > > > > > >
