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 date 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/dataperf0A
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
