I managed to figure out how to export a date from Filemaker via Json in a ISO date format.
However i am doing the reverse and now importing the date.
I have tried just the direct hoping filemaker will recognise the format, but no luck. just get a "?" response
Tried a customer function method "JSONGetDateFromISO"
Set Field [ TO_003____Invoices::Due Date ; JSONGetDateFromISO ( $invoices ; $ninja_due_date ) ]
but gives me a blank result.
the format that is returned in JSON is YYYY-MM-DD.
Any other ideas