You want to enter it as a variable in your report body, and then do a skip record if that variable = 0
Don [email protected] wrote: > 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] <mailto:[email protected]> > <[email protected] <mailto:[email protected]>> escribió: > > > > > De: [email protected] <mailto:[email protected]> <[email protected] > > <mailto:[email protected]>> > > > Asunto: [Dataperf] Report selecting two conditions in one field > > > Para: [email protected] <mailto:[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] <mailto:[email protected]> > > > http://lists.dataperfect.nl/mailman/listinfo/dataperf > > > > > > > > > > > _______________________________________________ > > Dataperf mailing list > > [email protected] <mailto:[email protected]> > > http://lists.dataperfect.nl/mailman/listinfo/dataperf > > > ------------------------------------------------------------------------ > Can't afford a new spring wardrobe? Go shopping in your closet instead > <http://www.stylelist.com/spring-fashion/spring-style/shopping-in-your-closet?ncid=emlweusstyl00000001>! > > > ------------------------------------------------------------------------ > > _______________________________________________ > Dataperf mailing list > [email protected] > http://lists.dataperfect.nl/mailman/listinfo/dataperf > _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
