Current Month

[nikol]

Hi,
How can I calculate the clients in a current month.Like this month is "july"so my query will calculate only july clients.
I know in crystal reports I have to use
({needs_services.provide_start_date}in MonthToDate)
Is there any way I can write this in sql.I'm using sql designer..

 

[Madawc]

In your record selection, say Month({needs_services.provide_start_date}) = MOnth(Currentdate)

Madawc Williams (East Anglia, UK)