Use Yesterday in expression

[gerhardl]

Hi,

please help me with this expression - cannot get it right:

Count({<[Posted Date]={"=date(today()-1)"}>} [Trans Amount])

I want to count the number of transactions that have a Posted Date of Yesterday.

Thanks in advance,

Gerhard

[tresesco]

use date format as 'YYYY/MM/DD'... it would work.

as

Count({<[Posted Date]={"=$(=date(today()-1,'YYYY/MM/DD'))"}>} [Trans Amount])

See attachment

[gerhardl]

I have QV Personal Edition so can't open your file - but I literally copy and paste that expression as it is and use it in the file I just uploaded and it does not work.

It returns a count of 4 payments received, when only 2 were received on 2012/08/30.

[#4 · Accepted solution]

Count({<[Posted Date]={"$(=date(vYESTERDAY))"}>} [Trans Amount])

you use [Posted date] instead [Posted Date]

[gerhardl]

Yes, thanks!

That's why I added that variable - then I made that stupid mistake. It works now.

Still don't understand why

Count({<[Posted Date]={"=$(=date(today()-1,'YYYY/MM/DD'))"}>} [Trans Amount])

doesn't work - but not matter.