Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

comparison the dates (Timestamp e Today)

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

4 Replies
lironbaram
Honored Contributor II

Re: comparison the dates (Timestamp e Today)

hi

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

maybe try converting both to numbers using num() function

Not applicable

Re: comparison the dates (Timestamp e Today)

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

lironbaram
Honored Contributor II

Re: comparison the dates (Timestamp e Today)

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.

Not applicable

Re: comparison the dates (Timestamp e Today)

Hello,

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

Thak's.

Community Browser