reducing of data from one field

[Anonymous]

I have a datefield which is having lot of data

now i just want to restrict it to one year data how to do that

[Anonymous]

i want to restrict the data to no more than one year,

currently its having two year data

[vinieme12]

LOAD *

From XXXXX

Where Year = Year(Today());

[Anonymous]

this is the case when you are having current year data (2017) ??

[parul_mehta]

Do you require from current date minus one year ?

from 20/4/2017 til 20/4/2016 ?

or only 2016 complete data ? ( Current year minus one years data  )

please provide more details?

[Anonymous]

from 20/4/2017 til 20/4/2016

[Peter_Cammaert]

LOAD *

FROM File.QVD (qvd)

WHERE Date >= AddMonths(Today(), -12);

To better prepare a fitting example, please post the script code with which you import your qvd.