Date

[ch_riadh]

LOAD

     Status,

     Stockid,

    Model,

    RECDATE,

    INVDATE

FROM

(qvd)  ;

My Customer want to show the Available Stock till the date selected.
with this Condition :

(     STATUS <> 0  and RECDATE  <= Selected_Date    )

or

(     STATUS = "I"   and RECDATE <= Selected_Date     and       INVDATE > Selected_Date    )

For example :
if i select ( march/2014),

i need to see : the stock available stock from 1900 til 31/03/2014.

and if a car received on 20/03/2014 and invoiced  on 02/04/2014  ----->    i have to show it.

but if a car received on 20/03/2014 and invoiced  on 28/03/2014  ----->    i dont want to show it.

;

[Gysbert_Wassenaar]

(     STATUS <> 0  and RECDATE  <= Selected_Date    )

or

(     STATUS = "I"   and RECDATE <= Selected_Date     and       INVDATE > Selected_Date    )

These conditions don't make sense. Status I is not 0 so the first condition will always apply to status I. Your second condition of the OR will never be tested

[ch_riadh]

ok
but how can i play with the date conditions ?