I could accomplish the above using loop to remove the current record from the the resultset that does not meet one of the condition referenced by the Database field but can it be achieved just by using proper @XResultSetSearch ( ) criteria?

var vRSHandle as int
var vNoOfRecords as int
var n as int

var vSuccess as Int



vRSHandle = @XResultSetSearch(@FN, "Index", SEARCH_MODE_AND, SEARCH_SYNTAX_QA, "!DateEntered=>{@Date - 180}", "!Action=Recalled")
     if(vRSHandle > -1)
     {
           vNoOfRecords = @XResultSetTotal(vRSHandle)
           For n = 1 to vNoOfRecords
                 xResultSetCurrentPosition (vRSHandle, n)
                 If @xResultSetValue (vRSHandle, "DateEntered") < @xResultSetValue (vRSHandle, "Date1") then
                       {
                             XResultSetRemoveRecord (vRSHandle)
                             n = n - 1
                             vNoOfRecords = vNoOfRecords - 1
                       }
           Next            
                 
           
           vSuccess = @xResultSetPrintReport ("Recall List", vRSHandle, Report_Mode_Print_Only_Preview)
           
           xResultSetClose (vRSHandle)
     }