Rather than having to refresh your dates every day, wouldn't it have been simpler to implement a view with dynamic dates?

Each refresh of the report is only ever pulling 2...

That is wonderfully simple, thanks Mark.

Seeing as we're on a roll, lets try for the complete set:

I can get the full Question node returned using this:

Question.query('.') AS...

• This reply was modified 4 years, 9 months ago by  Norty303.

Hmm, it appears that our XML Doc format is not consistent.

Sometimes the <question> sits at different levels.

So we see variations like this:

assessment/template/question

assessment/template/group/question

assessment/template/heading/group/question

and so forth.

Is there a syntax for selecting a...

Thank you Mark, that was the nudge I needed!

I'd looked at sql:column briefly and thought it looked somewhat set based.

Am I right in thinking you could do a similar thing...

My formative years of programming I used an ASCII facepalm art as the header block.

I felt it gave a good indication of what anyone might expect if they proceeded further. ...

This is basically the role of my team.
In a non IT business, why try and force IT skills (some quite complicated) on an unwilling workforce.
At best you're going...