I have two date fields within a table, while I can use the coalesce function to compare them, I then need to take the output from that and only display the year (substring(**output from the coalesce**,1,4). The only option I can find is to create a function that has a new field build in the table and then query it, but I'd rather not add another field.
