CRT team,
It seemed that you confused about specify start date and end date in ISQL script. If you would like to get data from 11/08/2015 – 13/08/2015 then in ISQL script you need to specify the command line like below (+1 day) after the range of date for data that you need.
and x.trans_date between '2015/08/11' and '2015/08/14', I think the data was incorrect because you specify the end range date as ‘2015/08/13’ so you have the data only 11 and 12 August which was incorrect.
I also run this report to F&A dept which correctly range date and send to them already. Please be careful about this error in the future