try this
SELECT start_date, end_date, project_title from tablename where
month(start_date)=09 and year(start_date)=04
this will show only the data pertaining to 09 month and 04 year.
hope this will resolve your problem.
with best wishes
balwant
-Original Message-
From: peppe
Hi Balwant your answer helpd me only I have a problem showing the projects
starting 06-05-2004 and ending 09-09-2005 I need to show also those projects
beacuse of end date is 2005
Balwantsingh [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
try this
SELECT start_date, end_date,