Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good afternoon,
I'm performing an incremental extraction in my database.
For it, I'm comparing a field of type timestamp with the function Today (), but this does not work, only it brings the fields nulls, if use a field of type Date, it work. I need use the timestamp.
How could comparate timestamp with the function Today()?
hi
both the field are numbers so you should be able to compare them
maybe try converting both to numbers using num() function
Hi Liron, I can not convert because I'm doing this in SELECT ... FROM, and Qlik Sense does not recognize the Num () function.
hi
you can do preceding load above the Select and use Qlik functions
your script should look something like:
Load field,
field1,
...
where ;
sql Select *
From;
because you don't use from in the upper section sense will use the table below as a source table.
Hello,
I solved the problem creating a variable with "Timestamp(Today())" and in code SQL does "SELECT * FROM WHERE Field = '$(vDateEnd)'".
Thak's.