Filter table on date

[jpjust]

ALL,

Sounds pretty simple but isnt working. 

I have a simple table.

TaskName          Task Created date

Task A                        2021-09-30

Task B                        2021-09-29

Now I want to display Task name where Task Created date = todays date.

So to accomplish that , on the table properties -> Data Handline -> Calculated Condition -> [Task Created]=today().

The result is the table isn't displaying anything while I expected to display the first record because today() returns 2021-09-30.

Anyone has any idea?

Thanks

[AshutoshBhumkar · Accepted solution]

Hi,

May be you can use below expression on dimension.

Expression : =Aggr(Only({<[Task Created date] = {'$(=Date(Today(),'YYYY-MM-DD'))'}>}TaskName),TaskName)

Uncheck Include null values

Thanks,

Ashutosh

[jpjust]

Thanks Ashutosh, that worked.