Change load date

[#1]

Hello!

I have a question aboat how i can change load date, i have a script i will load back in time with date as 2010-12-31, can i use "SET" in the beginnging of the scripr or?

I will load the script now but with the date 2010-12-31, do you understad me?

Somebody some have a idea?

[marcel_olmo]

Hi popalm,

if what you want is to load an static date, yes, I'd load statically a variable with "2010-12-31".

I'm not pretty sure about what you want, maybe replace your reloadTime() function with this date¿?

Hope it helps!

[prieper]

You may assign the required date to a variable and then refer to this variable in the script. Think that you should use LET rather than SET - the latter assigns a textstring (or a formula) to a variable, whereas LET assign values or results of an expression.

LET dStartDate = DATE#('12-31-2010', 'MM-DD-YYYY');
Table: LOAD * FROM .... WHERE MyDate >= $(dStartDate);

HTH
Peter

[#4]

I have tried but with no god result, i write SET date='2010-12-31'; in the begining of the script but it doesnt works, i se also data from 2011, i dont want that.

Can you help me with what should i write in the script

[#5]

i have many table to load, must i do this for every table?

[marcel_olmo]

So what you want is to filter the loading data until "2010-12-31".

If I were you, I will try Peter's solution. You have to do a LET (evaluated variable) to set your "maximumLoadingDate", and then load the table in your script filtering by that date.

Cheers!