topic Re: How to get Yesterday working with Google TimeStamp in QlikView

How to get Yesterday working with Google TimeStamp

mwscott1 — Tue, 27 Jan 2015 21:28:19 GMT

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.

Re: How to get Yesterday working with Google TimeStamp

sunny_talwar — Tue, 27 Jan 2015 21:32:21 GMT

Try this

=Date(Num(today()) -1, 'MM/DD/YYY')

Best,

Re: How to get Yesterday working with Google TimeStamp

Anonymous — Tue, 27 Jan 2015 22:12:10 GMT

Both your versions

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

work just fine for me...

Some info is missing (?) What does have to do with the Google timestamp?

Re: How to get Yesterday working with Google TimeStamp

MarcoWedel — Tue, 27 Jan 2015 22:26:09 GMT

Hi,

maybe you are looking for the day before the google timestamp:

DayName(Timestamp#(F2,'MM/DD/YYYY hh:mm:ss')-1)

should do.

hope this helps

regards

Marco