Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Miguel_Angel_Baeyens

Hi,

Just try instead

=Date(Today() -1)

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

Hope that helps.

Miguel

View solution in original post

2 Replies
Miguel_Angel_Baeyens

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
Author

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