Query Based on Date

Query Based on Date

I have a table where I track club affiliations. Each affiliation has a start date and end date. I would like to make a query that displays only affiliations that start after a certain date but I cannot get the SQL to work.

Here is my statement.

SELECT "ClubName","Region","ClubWebsite","VenueName","Address1","Address2","Town-City","PostCode","VenuePhone","startDate","endDate" FROM "Clubs","Club Affiliations" WHERE "startDate" >='2007-09-01 00:00:00'

I get no records even though I have several affiliations that are dated 01 Sep 2007 00:00:00 in the "Club Affiliation" table

Please help.