topic Howto: Count and filter based on date ? in App Development

Howto: Count and filter based on date ?

Thu, 14 Jan 2016 10:47:20 GMT

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 — Thu, 14 Jan 2016 18:28:18 GMT

May be this:

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

Fri, 15 Jan 2016 08:24:06 GMT

Thanks !