Hi @Wade0,
It seems to be an issue with the Data Type mismatch.
Try using {{ $luxon.DateTime.fromISO($json.date).toFormat(‘yyyy-MM-dd HH:mm:ss’) }}.
Adjust the format according to the expected format.
Ok so I installed invoice ninja locally and tested your claims. While expense_date is the valid and correct field for the expense request, it seems like this is a problem in invoice ninja itself ignoring the expense_date field. You seem to be correct that ‘date’ will set the actual date. I tested this both with the ninja node as well as making a direct http rest call to their API. Same results.
However, when using the http node and setting ‘date’, it seems like invoice ninja does use this as the date.
Thus, I wouldnt call this a bug in n8n’s invoice ninja node, however maybe a suggested enhancement to add the “Date” field as a possible input.
Having all that said, maybe for now, just use the http rest call direct when dealing with Expense creation if you want to set the date. See below example: