Longed for Geordie to do a turn at Hogmanay (4-3)
I believe the answer is:
year-end
'hogmanay' is the definition.
(Hogmanay means is New Year's Eve)
'longed for geordie to do a turn' is the wordplay.
I cannot really see how this works, but
'a' is present in the answer.
'turn' could be 'end' (ending is a kind of turning) and 'end' is present in the answer.
This may be the basis of the clue (or it may be nonsense).
'at' acts as a link.
(Other definitions for year-end that I've seen before include "Deanery (anag.)" , "Books prepared now" , "Last part of (financial) year" , "Last day of a twelve month period" .)