Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Count({<[Posted Date]={"$(=date(vYESTERDAY))"}>} [Trans Amount])
you use [Posted date] instead [Posted Date]
Thanks Tresesco,
but that's still not working. I now have:
Count({<[Posted Date]={"=$(=date(today()-1,'YYYY/MM/DD'))"}>} [Trans Amount])
But it gives me the same value as Count([Trans Amount])
you always have a scope of checking if the date(today()-1,'YYYY/MM/DD') producing the right date in right format. i guess the issue is with date format.
what is your date format?
SET DateFormat='YYYY/MM/DD';
Load
DATE(DATE#( left([Posted Date],11), 'DD-MMM-YY')) as [Posted Date],
could you send small sample qvw file ?
Did you try - Count({<[Posted Date]={"=$(=date(today()-1,'DD-MMM-YY'))"}>} [Trans Amount]) ?
Yes, that give me zero values.
Please see attached.