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

[#1]

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!

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

Just try instead

=Date(Today() -1)

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

Hope that helps.

Miguel

[#3]

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