Hello Louis,

It was the space in between Date and Completed that was causing the problem but not in the way you are thinking. DATE is a reserved keyword. So the programmed retrieve compiler got to the word Date, said that is not a field name, and gave an error.

-Ray

Here we go again with another multiple search issue.

I am trying to retrieve only those records where the CHQ_DATE is less than the current month and the MTH PAID is empty.

I have programmed a field as follows:

{@Year(CHQ_DATE) = @YEAR(@Date) and @Month(CHQ_DATE) = @Month(@Date) AND @ISBLANK(MTH PAID)}

This works to bring up the current month's cheques where month paid is empty.

When I place the less than sign in the retrieve, it doesn't bring up any records and there are various ones that match the criteria.

Samples tried:

<{@Year(CHQ_DATE) = @YEAR(@Date) and @Month(CHQ_DATE) = @Month(@Date) AND @ISBLANK(MTH PAID)}

{<(@Year(CHQ_DATE) = @YEAR(@Date) and @Month(CHQ_DATE) = @Month(@Date) AND @ISBLANK(MTH PAID))}

Am I missing something or am I mis-using the < sign ?

Louis

Ray:

Bingo !

I guess I had to compare the value first before asking it to retrieve the results.

Thanks for the quick response,

Louis