Howto: Count and filter based on date ?

[#1]

I would like to make this statement below dynamic - using the today's date or even better - last date a data loading was made

is that possible?. I have tried with a few options using (today([timer_mode]) that I found in help. but I don't seem to get the syntax right...

Count({<TASK = {'Defect'}, LoadDate={'2016-01-04'}>} Priority)

[sunny_talwar · Accepted solution]

May be this:

=Count({<TASK = {'Defect'}, LoadDate = {"$(=Date(Floor(ReloadTime()), 'YYYY-MM-DD'))"}>} Priority)

[#3]

Thanks !