Sage invoice paid date format issue

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

Hi @Leroy

You can parse and format the Sage payment date with the help of the date functions.


Just copy and paste this function into your scenario and replace the payment date variable with the Sage payment date.
{{formatDate(parseDate(31.payment date; “YYYY-DD-MM”); “YYYY-MM-DD”)}}