Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to filter data by specific date. However, it ends up showing full set despite of $ in the front.
I tried many different ways:
SUM({$<[DATE(TRANSACTION_DATE,'MM/DD/YYYY')]=[DATE(TODAY(1),'MM/DD/YYYY')]>} QUANTITY)
SUM({$<[INDAY(DATE(TRANSACTION_DATE,'MM/DD/YYYY'),DATE(TODAY(1),'MM/DD/YYYY'),0)]>} QUANTITY)
It ends up showing full set unless I use Date filter.
Please help.
Thanks.
sum({$ <TRANSACTION_DATE={"$(=Today())"}>} QUANTITY)
o r
sum({$ <TRANSACTION_DATE={"$(=date(Today(),'MM/DD/YYYY'))"}>} QUANTITY)
the format of the 2 dates should be the same
sum({$ <TRANSACTION_DATE={"$(=Today())"}>} QUANTITY)
o r
sum({$ <TRANSACTION_DATE={"$(=date(Today(),'MM/DD/YYYY'))"}>} QUANTITY)
the format of the 2 dates should be the same
That works. Thank you.