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!