Below are the Queries on How to Check Transactions Earlier than the Opening Date on MySQL yog, if Delete Transactions[Posted from Other Modules] is showing Empty

1.) SELECT * FROM JOURNAL1 WHERE D_ATE <= ‘2016/12/31’ AND FINCATCODE NOT IN (‘B55′,’B70’);

2.) SELECT * FROM journal1 WHERE D_ATE <= ‘2016/12/31’ AND acountcode = ‘xxx’; 

3.) SELECT * FROM journal1 WHERE D_ATE <= ‘2016/12/31’ AND cuscode = ‘xxx’;