Hi, hope someone could help me. I’m passing Sage invoices across to Airtable and everything is working perfectly, but I have noticed an issue with invoice payment dates.
The dates for invoice date and due date are passed to Airtable as YYYY-MM-DD but for some reason the payment date is passed as YYYY-DD-MM which is displaying incorrectly and causing confusion.
Can anyone offer any advise on how I can correct this?
Thank you