Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
;
( 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
ok
but how can i play with the date conditions ?