Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

mwscott1
Not applicable

How to get Yesterday working with Google TimeStamp

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.

3 Replies
sunny_talwar
Not applicable

Re: How to get Yesterday working with Google TimeStamp

Try this

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

Best,

S

mov
Not applicable

Re: How to get Yesterday working with Google TimeStamp

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?

MarcoWedel
Not applicable

Re: How to get Yesterday working with Google TimeStamp

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