Juan, I still get the incorrect argument error message :( Colin
-----Original Message----- From: Juan A. Salhus R. <[email protected]> To: [email protected] Sent: Tue, 28 Apr 2009 5:20 pm Subject: Re: [Dataperf] Report selecting two conditions in one field Hi, Colin you must type into an RV in a report body ex: CTRL-F7 1 4 100 AN ENTER THE FORMULA if P1F1 <= date[today] then 1 else if P1F1 = "" then 1 else 0 endif endif AFTER press ctrl-f7 9 1 (skip if rv100 IS false) SALUDOS --- El mar, 28/4/09, [email protected] <[email protected]> escribió: > De: [email protected] <[email protected]> > Asunto: Re: [Dataperf] Report selecting two conditions in one field > Para: [email protected] > Fecha: martes, 28 abril, 2009 8:42 > > Hi Juan, > > When I try to type that into the report header or body, the > error message is "Incorrect number of argumenst for > function." > > > > > > > > > > > -----Original Message----- > > From: Juan A. Salhus R. <[email protected]> > > To: [email protected] > > Sent: Tue, 28 Apr 2009 12:50 pm > > Subject: Re: [Dataperf] Report selecting two conditions in > one field > > > > > > > > > > > > > > hi Colin, > > USE > > > > if Field <= date[today] then 1 > > else if Field = "" then 1 > > else 0 > > endif > > endif > > > > --- El mar, 28/4/09, [email protected] > <[email protected]> > escribió: > > > > > De: [email protected] > <[email protected]> > > > Asunto: [Dataperf] Report selecting two conditions in > one field > > > Para: [email protected] > > > Fecha: martes, 28 abril, 2009 2:57 > > > G'day all, > > > > > > > > > > > > I need a report which collects records based on a > field > > > (text field, ? should be date field). Records > need to > > > be included which; > > > > > > 1 Have a d > ate equal to or before 'today's > > > date' in the field and > > > > > > 2 If the same field is blank. Thanks > > > > > > > > > > > > Colin Lambert > > > > > > Can't afford a new spring > > > wardrobe? Go > > > shopping in your closet instead! > > > > > > -----Adjunto en línea a continuación----- > > > > > > _______________________________________________ > > > Dataperf mailing list > > > [email protected] > > > http://lists.dataperfect.nl/mailman/listinfo/dataperf > > > > > > > > > > > _______________________________________________ > > Dataperf mailing list > > [email protected] > > http://lists.dataperfect.nl/mailman/listinfo/dataperf > > > > > > Can't afford a new spring > wardrobe? Go > shopping in your closet instead! > > -----Adjunto en línea a continuación----- > > _______________________________________________ > Dataperf mailing list > [email protected] > http://lists.dataperfect.nl/mailman/listinfo/dataperf > _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
