Data Load Editor, select specific Date range to be loaded

[ena1309]

HI guys,
 
is it possible and how to do in Data Load Editor, that the last two years only are loaded ?
 
i.e. this first line, to be something like DATE where Date= today(year) - 1 (or -2)  not sure what would be the solution

LOAD
Date(Date#([Run_Date], 'YYYYMMDD') ) AS [Run_Date],
[Division],
[Company_Code],
[Material_Number],
[Material_Description],
[HFI_Quantity],
[Stock_Value],
[Currency]
FROM Table.Example
(txt, unicode, embedded labels, delimiter is '|', msq);

THANK YOU IN ADVANCE
ENA

[vinieme12]

LOAD

Date(Date#([Run_Date], 'YYYYMMDD')  AS [Run_Date],

[Division],

[Company_Code],

[Material_Number],

[Material_Description],

[HFI_Quantity],

[Stock_Value],

[Currency]

FROM Table.Example

(txt, unicode, embedded labels, delimiter is '|', msq)

Where Date(Date#([Run_Date], 'YYYYMMDD') )>=yearstart(today(),-1);

[MarcoWedel]

If it's supposed to be a two years period, then maybe:

Where Date#(Run_Date,'YYYYMMDD') > AddYears(Today(),-2)