Good morning
I have designed a scenario in which I send invoices in pdf to a Webhook mail, and with pdf.co and a ChatGPT prompt I extract the main data in JSON format and then create a record in AIRTABLE. The scenario works fine except for a problem with the dates of the invoices. The problem is that the date in the output of the chatgpt module is in DD/MM/YYYY format, but when it enters Airtable, it takes it as YYYY/DD/MM. I have tried to use the formatdate formula but it doesn’t work either.
Context: In Spain the normal date format is DD/MM/YYYY as opposed to English format which is MM/DD/YYYY. It seems that Airtable is using the English format despite I’m indicating the desired format.
Do you know how it could be solved or why it happens?
Thanks
Can you show how you map the values in airtable? One solution could be to parse the json in between and then use the formatDate() function to bring it into the desired format. Can you also show how you used the formatDate() function?
Thanks, it seems to be solved now. Apparently, when I added a formatdate formula, for whatever reason it wasn’t saved…
I’ve reviewed the scenario again, and test it and now is working.
Best regards
1 Like