AVONFRS
asked on
SQL Select if between dates dynamic month and year
I have a table with a column of dates called COMPDATE
I need to select where is is the current month
So
SELECT COUNT(*) FROM COMPLETEDVISITS WHERE COMPDATE IS > [FIRST OF THE CURRENT MONTH] AND < [31 OF THE CURRENT MONTH]
how do i do this in sql
I need to select where is is the current month
So
SELECT COUNT(*) FROM COMPLETEDVISITS WHERE COMPDATE IS > [FIRST OF THE CURRENT MONTH] AND < [31 OF THE CURRENT MONTH]
how do i do this in sql
you need to use between function
SELECT COUNT(*) FROM COMPLETEDVISITS WHERE COMPDATE BETWEEN [FIRST OF THE CURRENT MONTH] AND [31 OF THE CURRENT MONTH]
SELECT COUNT(*) FROM COMPLETEDVISITS WHERE COMPDATE BETWEEN [FIRST OF THE CURRENT MONTH] AND [31 OF THE CURRENT MONTH]
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
WHERE date(year,COMPDATE) = datepart(year, getdate())
and date(month,COMPDATE) = datepart(month, getdate())