While it's always a good idea to use standard ascii-characters and no spaces, You can handle it this way:
** Sorry for typing mistakes - but it's impossible to edit postings on iPad here
Yes, but you don't actually need Execute SQL do to this.
You can use a sorted FileMaker Relationship or a sorted Portal to sort your related records by year in descending order. You can then put the field from the related table (sorted relationship) or a one row portal (sorted portal) to show this information for the most recent project year.
Thanks Marcus Schneider and PhilModJunk!
It would indeed be possible with the sorted portal but I thought it would be a good exercise to try the ExecuteSQL as I will also need this for some of my graphs
The link explained everything very well!