Discussion Board for collaboration related to QlikView App Development.
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())
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)
View solution in original post
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
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?
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