3 Replies Latest reply: Jan 27, 2015 5:26 PM by Marco Wedel RSS

    How to get Yesterday working with Google TimeStamp

    Melvin Scott

      I am pulling in a time stamp from a Google spreadsheet (Example 12/22/2014 16:20:18). I am using subfield to get the date to to be 'MM/DD/YYY' and load as DATE

       

      DATE(Subfield(F2,' ',1), 'MM/DD/YYYY') as DATE,

       

      I can use

       

      =DATE((today()), 'MM/DD/YYYY')

       

      to get Today, but

       

      =DATE((today()-1), 'MM/DD/YYYY') or =DATE(today()-1)

       

      will not get Yesterday.

       

      Any ideas

       

      Thanks.