Edit Report:Expired Credit Cards
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- Expired Credit Cards
-- Cards expiring
select d.debtorno , d.name, d.address1,
d.address2,
d.address3,
d.address4,
d.address5,
c.card_type,
c.name,
c.number,
c.expiry_month,
c.expiry_year
from credit_cards_net c
join debtorsmaster d on d.debtorno = c.debtorno
where concat(c.expiry_year,c.expiry_month) < DATE_FORMAT(NOW(),'%y%m');