Struggling with a COUNT(QUERY

Good Day All

Im trying to count the amount of times a specific value appears in a different sheet on the same workbook
These must be separated by month (a column in the data sheet contains the date)

Ive been trying:
=COUNT(QUERY(scandata, "select D where D<'6/01/2018' & D>'4/30/2018' ))"))

seems to return a zero value when I know for a fact there are at least 4x in that month.

Thank you very much for reading!

Thank you so much

Unfortunately I need to count the amount of times a Value appears dependant on the actual value (in this case VALUE is a medical "PracticeID")
there are +2000 different practices and I need to see how many scans were done (each line on the data sheet represents a scan) with the date of said scan.

Practices sheet needs to represent amount of scans per month
Scans sheet has the data on it (PracticeiD & DateTime)

Please see attached images:
scans data.JPGpractices.JPG

Thank you, Im unsure how to use Pivot.

in the larger pic(Data) is all the scans my business has done.
both pages have a "PracticeID"

I want to represent how many of the scans related to each PracticeID were in each month
Will try COUNTIF now

Thnak you

all sorted guys!
thank you very much for the help, Ive used:
=count(query(scandata,"select A where F=" & $A249 & " and D >= date '" & text(date($H$1,I$2,1),"yyyy-mm-dd" ) & "' and D < date '" & text(edate(date($H$1,I$2,1),1),"yyyy-mm-dd" ) & "'"))

HI again.
sorry, im brand new to the forum.

Ive managed to get it to work on google sheets, however It is seriously slow and im getting nowhere..

I cant help but wonder if my machine will calculate much faster on excel.

Problem is this isnt compatible with excel:

=count(query(Sheet1! A where F=" & $A3 & " and D >= date '" & text(date($H$1,H$2,1),"yyyy-mm-dd" ) & "' and D < date '" & text(edate(date($H$1,H$2,1),1),"yyyy-mm-dd" ) & "'"))

Thank you again!
goo to mic.JPG