I have a column of date in mm/dd/yyyy format in my table and it's data type is text.
My objective is to extract only month and year from that table with a specific name.Example:
ID Name Date
01 SAM 09/02/2012
02 DAVID 08/05/2012
I want the exact query to get the O/P.I am using c#.net in front end and access 2003 in the system.
Thanks.