AnsweredAssumed Answered

Import date from JSON in ISO format

Question asked by Paul_Mellor on Feb 20, 2019
Latest reply on Feb 21, 2019 by Paul_Mellor

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

Outcomes