I need to populate a select box with the years available from a database. The full dates are stored in the database, but I just need the years(no duplicates, of course). I don't care if they come directly from my query, or if I have to do some manipulation in CF before I use them. I just need them! There is one record for each day. Any ideas? Here is my current query, that obviously, doesn't do much except return all record dates...
Code:
SELECT IncidentDate FROM Incident