I have the following query:
SELECT dbo.CONTENT_Event.eventID, dbo.CONTENT_Event.EventName + ' (' + EventOrgName + ')'
INNER JOIN dbo.CONTENT_Event
ON View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = dbo.CONTENT_Event.[eventID]
I want a WHERE condition to return events for the current date and all future dates (ie. exclude past events), based on the dbo.CONTENT_Event.EventDate field (datetime).
Can anyone help out with the syntax?