topic Re: Data Load Editor, select specific Date range to be loaded in App Development

Data Load Editor, select specific Date range to be loaded

ena1309 — Thu, 02 Jun 2022 12:50:48 GMT

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

Re: Data Load Editor, select specific Date range to be loaded

vinieme12 — Thu, 02 Jun 2022 14:51:45 GMT

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);

Re: Data Load Editor, select specific Date range to be loaded

MarcoWedel — Thu, 02 Jun 2022 21:14:43 GMT

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

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