topic Re: How to subtract 5 min from timestamp in QlikView

How to subtract 5 min from timestamp

sspawar88 — Fri, 10 Jul 2015 08:59:33 GMT

i want to subtract a 5 min from today timestamp.

How can i get result for this in red()

if(Max(created_date)<> timestamp(today(),'DD-MM-YYYY hh:mm:ss') ,red())

jonathandienst — Fri, 10 Jul 2015 09:01:41 GMT

This will subtract 5 minutes from the current time

TimeStamp(now() - 5 / (24*60))

(Today() contains the date only, now() contains the date and time - and there are 24 * 60 minutes per day)

sspawar88 — Fri, 10 Jul 2015 09:08:29 GMT

i want to check it for a data which is in my excel files.

how can i apply it for existing database

7/8/2015 11:57:31 PM--this is my last date

jonathandienst — Fri, 10 Jul 2015 09:39:22 GMT

I don't understand your question. Do you want to look for 5 minutes ago, or do you want to check when you last reloaded?

sspawar88 — Fri, 10 Jul 2015 09:45:28 GMT

In table object consist ID's, Min(created_date) and Max(created_date)

if i want to check whether this ID is updated in last 5 min or not..if this is not updated i want to show in red().

is this expression correct ?

if(Max(created_date)<> Max(created_date)- 5/(24*60) ,red())

Max(created_date) is 7/8/2015 11:57:31 PM