/
Correcting empty dates on Receipts

Correcting empty dates on Receipts

Owned by Daniel Ruggieri (Unlicensed)
Sept 09, 2022

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.

Add label

Related content