Well I got it wrong, despite already using XML indexes.

I suspect this is because the question made no mention of the date format set on the database 😉