Hello,
I have run that query in Navicat, and I get various (and correct) results according to the (WEEKDAY(cancellationdates.cancelleddate)=0) variable. I get 2 results on Monday (value = 0), 1 result on Tuesday (value = 1) and 1 result on Thursday (value = 3).
I have put the ftp details in the private area.
Thank you,
KAB