Filtering data based on date

[sridhar_sigired]

Dear Team,

I have 2007-2011 data, where i have to read only latest 3 years data. I have order date field. I am trying with below line, but not working. Can you please give me the solution.

Created two variables - vMaxYear    =Year(today())-4 (2011)

                                  vMinYear     =Year(today())-6 (2009)

Load

    OrderID,

     Year(OrderDate) as YearOrderDate,

     ShipperID

FROM

[..\Stage1\Orders.qvd]

(qvd) Where Year(OrderDate) >=$('vMinYear') and Year(OrderDate) <=$('vMaxYear');

Regards,

Sridhar

[#2]

Can you please load your app here