Hiya guys, I am trying to pull out records as entered into the database. But I only want to pull out records that have a date in the date column that is today's date or further into the future. Dates before today's date I do not want to display. The issue I have is that I have created a WHERE clause which does this but does not display records with today's date, only future dates beyond today's date. This is my code so far: IF @EventCategory = 'All Events' BEGIN SET LANGUAGE british Declare @Today DATETIME SET @Today = GETDATE() SELECT ceav_title.Value AS Title, CAST(ceav_startdate.Value as datetime) AS StartDate, FROM ContentElement ce LEFT JOIN ContentElementAttributeValue AS ceav_title ON ceav_title.AttributeID = 17 AND ceav_title.ContentElementID = ce.ID LEFT JOIN ContentElementAttributeValue AS ceav_startdate ON ceav_startdate.AttributeID = 24 AND ceav_startdate.ContentElementID = ce.ID WHERE TypeID =1 And CAST(ceav_startdate.Value as datetime) >= @Today ORDER BY StartDate ASC END ELSE BEGIN PRINT 'An Error has occurred!' END Can someone help? What have I missed? Thanks in advance!