how to filter data by date in a load script?

[Bruno_Basulto]

Hi all,

I need to filter when performing a data load from an Oracle connection using a date and time field that has the following format:

"FEC_SOL" : '2023-01-01 00:00:00.000000'

to bring only information from 2023 onwards.

Thank you!

[MatheusC · Accepted solution]

Hi, @Bruno_Basulto 

From the example, it appears to be a datetime field,

Could you do this in Load instead of Select?

see below

load
...
Where year(Date(Floor(datetime)))>=year(today())-1;

[Table];
Select
...
from;

Regarts,
Matheus

[MatheusC]

Did you get the solution?

Close the topic with the solution met and leave a like if you found it useful.

Thank you!

[anat]

select * from table where EXTRACT(YEAR FROM datefield) >=year(today())-1

[Bruno_Basulto]

Yes! its work!
Thanks.

[WaltShpuntoff]

When you are using the Today function in a load script, you should always use Today(1), since Today() or Today(0) is the date of the last successful reload. If you are doing daily updates this makes a big difference.

For details:

Qlik Help for Today() function 

ws