I understand, thank you for your reply - I have built a plugin which parses the date string so I'm able to do this, even though it's a bit of a hack 😅
That does lead me to a follow up question though - is there a native way in the Automad template syntax to iterate through a pagelist returned by a plugin, can this be assigned to a variable? Or am I better off just using native PHP?