Marc Works for me here. Make sure a variable with that name is not already defined as another data type. Not in the report, but predefined in your app, lurking in the background maybe?
Dawn -----Original Message----- From: Marc [mailto:[EMAIL PROTECTED] Sent: Thursday, March 03, 2005 10:50 AM To: RBG7-L Mailing List 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 > >
