i had an issue that, our customer having different types of credit cards like,amex,mcvs .So, these are divide into 14 batches like,Amex-MON,MCVS-oMON,AMEX,TUE AND MCVS-TUE ETC..FOR ALL BATCHES.
I had created a report a report to post the deposited lines from deposit order.It will check the records for thier respective day and picks the batch,for example if today is monday it will pick AMEX-MON AND MCVS-MON batches and checks if any lines are their and if so it will be posted,So my issue is Saturday and sunday batches are supposed to be posted on monday,So plese help me out Code i wrote was
Date.SETRANGE("Period Type",Date."Period Type"::Date);
DepositHeader.SETFILTER("Journal Batch Name",'%1|%2','AMEX-'+UPPERCASE(COPYSTR(Date."Period Name",1,3)),'MCVS-'+