Sage invoice paid date format issue

How To
1

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

2

Hi @Leroy

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

image
image452×127 5.46 KB

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”)}}