The queryNew() function is not treating date columns as date objects. If the value is original passed as a string, it stays a string, which can cause issues when expecting the column value to be treated as a date.

For example:

I would expect the sdf.format(data.modified[1]); line to execute (as it does in ACF 10+), but instead it throws an exception. You have to change the line to:

I would expect columns defined as a date to be treated as a date like it does in ACF.

Here's a Gist that shows the behavior:

https://www.trycf.com/gist/a1878db461c0b1ceb6659c7441b3ab86/lucee5?theme=monokai