I need a where clause on task..where its calculates the count of tasks every week between Friday and Thursday..
I know it will be a Aggregate query.I am confused how to calculate every-week..What will be the where clause..I don't need "THIS_WEEK" condition..I need to calculate the task every week between Friday and Thursday.
Please help with the logic of dates so it works dynamically everyweek.
Please its urgent
List<aggregateResult> results1=[Select ownerId, count(id) totalCount from task group by ownerId