InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 07:11:22 GMT20http://www.sqlservercentral.com/Forums/Topic1403620-1292-1.aspxThis works perfectly. Thank you very much :)Mon, 07 Jan 2013 08:15:16 GMTsqlrd22http://www.sqlservercentral.com/Forums/Topic1403620-1292-1.aspxTry this:[code="sql"]DECLARE @Date DATE = GETDATE();SELECT *FROM Client_Trades.DBO.TradesWHERE Trade_Date >= DATEADD(MONTH, DATEDIFF(MONTH, 0, @Date), 0)AND Trade_Date < DATEADD(MONTH, DATEDIFF(MONTH, 0, @Date)+1, 0);[/code]What that does is calculate the first day of the current month, and the first day of the next month. Then it makes sure the Trade_Date >= first day of current, and < first day of next month.Does that do what you need?Mon, 07 Jan 2013 08:08:41 GMTGSquaredhttp://www.sqlservercentral.com/Forums/Topic1403620-1292-1.aspxHi, I use a very basic select query[code]SELECT * FROM Client_Trades.DBO.TradesWHERE MONTH(Trade_Date) = '01'[/code]To extract records from a particular month. Is there any way of me not having to change the value e.g. '01' every month and just having it so it selects from the current month?Thanks for any help.EDIT: Trade_Date is a Date datatype.Mon, 07 Jan 2013 07:53:37 GMTsqlrd22