topic Re: Compare timestamp with time(now) in QlikView

Compare timestamp with time(now)

Mon, 15 Dec 2014 10:08:45 GMT

I have a updatefield with timestamp of last update. 'YYYY-MM-DD hh:mm:ss'

For a IF expresseion that checks if the script should continue I need it to check if the timestamp are larger/later then 20:00 (8 pm) yesterday.

How should I do that check?

Re: Compare timestamp with time(now)

MK_QSL — Mon, 15 Dec 2014 10:19:33 GMT

Let vTime = Time(Frac(Timestamp('$(vLastReloadTime)')),'hh:mm');

IF (vTime >= Time#('20:00','hh:mm')) THEN

YOURSCRIPT.....

ELSE

ENDIF

Let vLastReloadTime = ReloadTime();

Re: Compare timestamp with time(now)

Mon, 15 Dec 2014 12:22:55 GMT

Thank you. but I also need to check that the date is a maximum of one day back in time. It is to be approved is one day back but at least 20:00 or today's date (regardless of time)

Re: Compare timestamp with time(now)

MK_QSL — Mon, 15 Dec 2014 12:24:08 GMT

Can you elaborate little more pls?

Re: Compare timestamp with time(now)

MK_QSL — Mon, 15 Dec 2014 12:36:03 GMT

Let vReLoadDate = Date(Floor(Timestamp('$(vLastReloadTime)')));

Let vTime = Time(Frac(Timestamp('$(vLastReloadTime)')),'hh:mm');

IF(vReloadDate < Date(Today())) THEN

YourScript

ELSE

IF (vTime >= Time#('12:00','hh:mm')) THEN

YourScript

ENDIF

Let vLastReloadTime = ReloadTime();

Re: Compare timestamp with time(now)

Mon, 15 Dec 2014 12:40:20 GMT

I will try...

The qvw script runs on three occasions during the period between 03:00 and 12:00 and I want to cancel it if the db is not updated. The db should be updated every night. Sometimes it goes quickly and then field UdpUpdate is = TODAY()-1 and Time> 20:00.

At the end of the month it goes a little slower and then the update sometimes are dealyed and are to be completed TODAY() from 00:00 onwards.

I just want the script to check if the field UdpUpdate shows a higher value than yesterday's date and time > 20:00 or and aslo date(today())

Re: Compare timestamp with time(now)

MarcoWedel — Mon, 15 Dec 2014 12:43:03 GMT

If(TimestampLastUpdate > DayStart(Today())-1/6, dosomething, dosomethingelse)

Re: Compare timestamp with time(now)

Mon, 15 Dec 2014 12:59:49 GMT

Thanks. It shoudl work but I cant get it to work.. I have atteaced a sample with the latest timestamp check from the db