This content has been marked as final. Show 3 replies
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
to get Today, but
=DATE((today()-1), 'MM/DD/YYYY') or =DATE(today()-1)
will not get Yesterday.