Hi guys,

Any idea on how to filter the records by 'Month' using SQL query, if the date format  is stored as MM/DD/YYYY and I only wish to filter these records by month...

If I write my SQL query as "SELECT * FROM TABLE1 WHERE DATE = ", it will filter by the date only...

Thank you...


Gary