Need a list of years from dates

[Chloeee]

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...

SELECT IncidentDate FROM Incident

 

[KevinFSI]

If you only want to pull individual years in the query, you can do this:

SELECT DISTINCT YEAR(IncidentDate) AS incidentYear
FROM Incident
ORDER BY incidentYear

This will return all the years (with no duplicates) in your Incident table. Kevin
slanek@ssd.fsi.com

 

[Chloeee]

That works perfectly; thank you so much!

 

[KevinFSI]

No problem. Have fun. Kevin
slanek@ssd.fsi.com