Hi,

I currently use the following code to select records of the current month and year.

Code:
SELECT * FROM x where  DATEADD(mm,DATEDIFF(mm,0,dateofservice),0)=DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0)
But now I would only like to show records of the current month but only for current day and future days of the month.
(ex. assuming tday is 03/13/2013

TO SHOW
03/13/2013 ... 03/31/2013

NOT TO SHOW
03/01/2013 ... 03/12/2013

I was wondering if you could give me some tips on how to make this work.

Thanks