Hi Brent,
Can you provide the exact query you are trying to use? And a copy of your xlsx form so we can try to do further testing?
I am not sure this type of complex query is supported due to recent changes to AGO which do not allow non Standardized SQL expressions. Only standard SQL expressions can be used, so if the expression requires non-standard operators, it will not work.
Regards,
Phil.