topic Re: comparison the dates (Timestamp e Today) in App Development

comparison the dates (Timestamp e Today)

Thu, 11 May 2017 14:34:43 GMT

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

Re: comparison the dates (Timestamp e Today)

lironbaram — Thu, 11 May 2017 17:52:45 GMT

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

maybe try converting both to numbers using num() function

Re: comparison the dates (Timestamp e Today)

Thu, 11 May 2017 18:32:12 GMT

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

Re: comparison the dates (Timestamp e Today)

lironbaram — Sun, 14 May 2017 06:16:08 GMT

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.

Re: comparison the dates (Timestamp e Today)

Fri, 19 May 2017 19:58:15 GMT

Hello,

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

Thak's.