[Resolved - with issues]TableAdapter SQL DISTINCT Year

[Bruce Fox]

Hi Guys,

Prior to VB.Net 2005, I could return distinct years from a DateTime field by prefixing the field in the SQL statement with the Year() function (Eg: "SELECT DISTINCT Year[Log_Date] FROM tbl_Logbook GROUP BY Year[Log_Date]").

However, I cannot figure out how to do it with a DataTable/TableAdapter SQL in 2005 with the following SQL statement as 'Year' is an unrecognised function.

SELECT DISTINCT Year[Log_Date] FROM tbl_Logbook GROUP BY Year[Log_Date]

I have used the TableAdapter Configuration Wizard to no avail.


What I need is unique, distinct years from a DB.
Eg.

Log_Date column may have the following values: 23/5/2001, 28/6/2001, 2/9/2004

I need to return all records (grouped) by year, ie: 2001 and 2004.

Ideas?