Using date in IF statement for the Record Selection 1

[willz99ta]

Thanks for your help,

I am using this record selection query:

if {PURCHORDER.PO_DATE} >= date(2010,04,01) then ({PURCHORDER.PO_USER_FLD_1} <> "C")

The problem is that it only returns the data that matches this: {PURCHORDER.PO_DATE} >= date(2010,04,01)


Any ideas?

Thanks,
Will

 

[lbass]

(
(
{PURCHORDER.PO_DATE} >= date(2010,04,01) and
{PURCHORDER.PO_USER_FLD_1} <> "C"
) or
{PURCHORDER.PO_DATE} < date(2010,04,01)
)

...if the intent is to limit to "c" records if later than 4/1, but not limit earlier records.

-LB