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
