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