Date sent from N8N not accepted

Hi @lcx_at,
After trying few things, it seems that a date column needs a date object as input… Something like that should do the trick in your Column value :

{{ new Date($('Switch').item.json["Invoice Date"].split('-')[0],$('Switch').item.json["Invoice Date"].split('-')[1],$('Switch').item.json["Invoice Date"].split('-')[2]) }}

Bests,
Benjamin