Very strange, a query function I have used for years with no issue is not working on my latest google sheet.

It keeps saying no output even though I know it should have an output.

This is the query

=(Query(Results!A2:E,"Select A,C,B,D,E Where A >= date '"&TEXT(B10,"yyyy-MM-dd")&"' and A <= date '"&TEXT(B10,"yyyy-MM-dd")&"' "&if(len(J6)," and C='"&J6&"' ",)&" Order by A Desc",0))

You can view the sheet at: