comparison the dates (Timestamp e Today)

[#1]

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()?

[lironbaram]

hi

both the field are numbers so you should be able to compare them

maybe try converting both to numbers using num() function

[#3]

Hi Liron, I can not convert because I'm doing this in SELECT ... FROM, and Qlik Sense does not recognize the Num () function.

[lironbaram]

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.

[#5]

Hello,

I solved the problem creating a variable with "Timestamp(Today())" and in code SQL does "SELECT * FROM WHERE Field = '$(vDateEnd)'".

Thak's.