{"record":{"id":"1591dcc9ff0c9737","repo":"Budibase/budibase","slug":"invalid-date-format-for-column-col-row-col","errorCode":null,"errorMessage":"Invalid date format for column ${col}: ${row[col]}","messagePattern":"Invalid date format for column (.+?): (.+?)","errorType":"validation","errorClass":null,"httpStatus":null,"severity":"error","filePath":"packages/server/src/utilities/rowProcessor/utils.ts","lineNumber":261,"sourceCode":"      continue\n    }\n    if (schema.dateOnly) {\n      continue\n    }\n    if (!schema.timeOnly && !schema.ignoreTimezones) {\n      datesWithTZ.push(column)\n    }\n  }\n\n  for (const row of rows) {\n    for (const col of datesWithTZ) {\n      if (row[col] && typeof row[col] === \"string\" && !row[col].endsWith(\"Z\")) {\n        let date = new Date(row[col] + \"Z\")\n        if (isNaN(date.getTime())) {\n          date = new Date(row[col])\n        }\n        if (isNaN(date.getTime())) {\n          throw new Error(`Invalid date format for column ${col}: ${row[col]}`)\n        }\n        row[col] = date.toISOString()\n      }\n    }\n  }\n\n  return (Array.isArray(inputRows) ? rows : rows[0]) as T\n}\n","sourceCodeStart":243,"sourceCodeEnd":270,"githubUrl":"https://github.com/Budibase/budibase/blob/a81a902e9a8fe55b467d106765f6638f12e35c49/packages/server/src/utilities/rowProcessor/utils.ts#L243-L270","documentation":"Error \"Invalid date format for column ${col}: ${row[col]}\" thrown in Budibase/budibase.","triggerScenarios":"Thrown at packages/server/src/utilities/rowProcessor/utils.ts:261 when the library encounters an invalid state.","commonSituations":"See trigger scenarios.","solutions":[],"exampleFix":null,"handlingStrategy":null,"validationCode":null,"typeGuard":null,"tryCatchPattern":null,"preventionTips":[],"tags":[],"backgroundTag":null,"analyzedSha":"a81a902e9a8fe55b467d106765f6638f12e35c49","analyzedAt":"2026-08-29T01:03:10.972Z","schemaVersion":2},"datasetVersion":"2026-08-29T02:17:18.158Z"}