/
Correcting empty dates on Receipts

Correcting empty dates on Receipts

There appears to be an issue with postmarked bills showing the linux epoch when printing the receipt.

select concat("update ppt_transactions set postmark_date='", last_day(date_add(t.work_date, interval -1 month)), "' where id = ",t.id,";") q from ppt_transactions t join receipt_payments rp ON(rp.receipt_id = t.receipt_id) where (t.postmark_date IS NULL OR t.postmark_date ='0000-00-00') and rp.via ='POSTMARKED_MAIL';

 

Related articles

Filter by label

There are no items with the selected labels at this time.

Related content