Luxon 'Invalid DateTime' Error When Formatting ISO Dates in Google Sheets Workflow

I'm encountering an issue while transferring ISO date strings from Postgres to Google Sheets in an n8n workflow. The error message Invalid DateTime appears for the keys appointment_date and lead_submitted_date on every row once the Google Sheets node completes.

The problematic JavaScript expressions are as follows:

JAVASCRIPTCopied
{{ $json.appointment_date_est ? DateTime.fromISO($json.appointment_date_est, {zone: 'utc'}).format('yyyy-LL-dd') : null }}

JAVASCRIPTCopied
{{ $json.lead_submitted_date_est ? DateTime.fromISO($json.lead_submitted_date_est, {zone: 'utc'}).format('yyyy-LL-dd') : null }}

This setup works correctly when I test only the Google Sheets node in isolation; however, the issue occurs when running the full workflow. I attempted adding a wait node before the Google Sheets node to account for potential data delays, but this did not resolve the problem. I recently updated to version 1.75.2 and cannot perform a rollback, so I suspect there might be a regression or configuration change affecting the parsing behavior.

The output from the last node is an array of objects like this:

JSONCopied
{
  "surrogate_key": "key",
  "appointment_id": 1,
  "user_id": 1,
  "appointment_date": "Invalid DateTime",
  "lead_submitted_date": "Invalid DateTime",
  "first_name": "Test",
  "last_name": "Test",
  "email": "test@gmail.com",
  "dietitian_name": "Test",
  "tracking_data_json": {
    "utm_source": "test",
    "utm_medium": "email",
    "utm_campaign": "test"
  },
  "traffic_channel": "ads",
  "appointment_type_name": "test",
  "appointment_status": "test",
  "contact_type": "test"
}

The input is similarly structured as an array of objects:

JSONCopied
{
  "surrogate_key": "key",
  "appointment_id": 1,
  "user_id": 1,
  "first_name": "Test",
  "last_name": "Test",
  "email": "test@gmail.com",
  "appointment_date_est": "2024-10-31T00:00:00.000Z",
  "lead_submitted_date_est": "2024-10-27T00:00:00.000Z",
  "dietitian_name": "Test",
  "tracking_data_json": {
    "utm_source": "test",
    "utm_medium": "email",
    "utm_campaign": "test"
  },
  "traffic_channel": "ads",
  "appointment_type_name": "test",
  "appointment_status": "test",
  "contact_type": "test"
},

Setup details:

• n8n version: 1.75.2
• Running n8n via: cloud
• Database: n/a
• Operating system: n/a

Any help, recommendations, or additional insights would be greatly appreciated.