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/dataperf
