Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Today()-1 won't work how will I select yesterday

Dear all,

I'm trying to always select yesterday in my data set because we don't have real life data and yesterday is the most recent data. But when selected an action in triggers i use today() result is today because we reload after 12pm.

So i want the data from yesterday  I tried today()-1 it doesn't work. Hope anyone could help me. Thanks!

1 Solution

Accepted Solutions
MVP
MVP

Re: Today()-1 won't work how will I select yesterday

Hi,

Just try instead

=Date(Today() -1)

The Date() function should return in the same format your date field is.

Hope that helps.

Miguel

2 Replies
MVP
MVP

Re: Today()-1 won't work how will I select yesterday

Hi,

Just try instead

=Date(Today() -1)

The Date() function should return in the same format your date field is.

Hope that helps.

Miguel

Not applicable

Today()-1 won't work how will I select yesterday

Thanks! Finally it will work! Usefull help around here,

Community Browser