Count Availability time slot in a specific date range

[gianlucabiancardi96]

Hei guys
Think i miss this.

I have specialized doctors that put time availability in their dashbaord.
Every availability is saved in the DB in Date format.
Now I want an internal dashbaord where I can see how many availability each doctor put every next week.

How do I count them in a “next week” time range?

[mikeloc]

Hi there, @gianlucabiancardi96… if I understand your post correctly, you need search constraints that look something like this.

availability date >= Current date/time:rounded down to week +(days): 7
availability date < Current date/time:rounded down to week +(days): 14

Hope this helps.

Best…
Mike