Budibase/budibase · error

Invalid date format for column ${col}: ${row[col]}

Error message

Invalid date format for column ${col}: ${row[col]}

What it means

Error "Invalid date format for column ${col}: ${row[col]}" thrown in Budibase/budibase.

Source

Thrown at packages/server/src/utilities/rowProcessor/utils.ts:261

      continue
    }
    if (schema.dateOnly) {
      continue
    }
    if (!schema.timeOnly && !schema.ignoreTimezones) {
      datesWithTZ.push(column)
    }
  }

  for (const row of rows) {
    for (const col of datesWithTZ) {
      if (row[col] && typeof row[col] === "string" && !row[col].endsWith("Z")) {
        let date = new Date(row[col] + "Z")
        if (isNaN(date.getTime())) {
          date = new Date(row[col])
        }
        if (isNaN(date.getTime())) {
          throw new Error(`Invalid date format for column ${col}: ${row[col]}`)
        }
        row[col] = date.toISOString()
      }
    }
  }

  return (Array.isArray(inputRows) ? rows : rows[0]) as T
}

View on GitHub (pinned to a81a902e9a)

When it happens

Trigger: Thrown at packages/server/src/utilities/rowProcessor/utils.ts:261 when the library encounters an invalid state.

Common situations: See trigger scenarios.

AI-assisted analysis of Budibase/budibase@a81a902e9a (2026-08-29). Data as JSON: /api/errors/1591dcc9ff0c9737. Report an issue: GitHub.