2 Replies Latest reply: Dec 20, 2011 10:12 AM by Miguel Angel Baeyens de Arce RSS

    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!