How to count number of records

hi friend you can do write the query in below format : declare @act_date date = '2/2/2012' //login date declare @newact_date date set @newact_date = DATEADD(month, 1, @act_date) select COUNT(@newact_date) where @act_date <=GETDATE() .hope it will be helpful