I am running Coldfusion 9 and SQL 2008 and am trying to write a query to merge two date columns (openDate and pastDate) from the same table into one column and extract the year from it so I can sort by year.
<cfquery name="getPast" datasource="Exhibitions">
select Year(openDate + pastDate) as exhibitYear
order by exhibitYear desc
but this just gives me an empty string for all records.
Is there a way to do this?