Unable to filter by Date

[#1]

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.

[maxgro · Accepted solution]

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

[#3]

That works. Thank you.