Is date

Input

value

Validate that value is a valid date

validation:

date

Validate date format

source:value

Output

result
Pass
Pass
Pass
Date validation failed for field "value"
Date validation failed for field "value"
Date validation failed for field "value"

* Sample inputs run locally in your browser using the same operation logic as Fontana Flow.
Results are illustrative, not connected to a workflow.

Validate date format.

Parameters

• formats (array, optional) — Array of date formats to validate against (uses defaults if empty). Default: ["yyyy-MM-dd","MM/dd/yyyy","dd-MM-yyyy","dd-MM-yy","yyyy/MM/dd","dd/MM/yyyy","MM/dd/yy"].

Field selection

• source — Field whose values this operation reads. Omit to apply to all fields on the row.
• target — Optional output field. When omitted, the source field is updated in place.

JSON Configuration

{
  "id": "op-date",
  "type": "validation",
  "action": "date",
  "params": {
    "formats": [
      "yyyy-MM-dd",
      "MM/dd/yyyy",
      "dd-MM-yyyy",
      "dd-MM-yy",
      "yyyy/MM/dd",
      "dd/MM/yyyy",
      "MM/dd/yy"
    ],
    "inputFormats": [
      "yyyy-MM-dd",
      "MM/dd/yyyy"
    ],
    "outputFormat": "MM/dd/yyyy"
  },
  "testInputs": [
    "2024-01-15",
    "2024-06-01",
    "2023-12-31",
    "not-a-date",
    "2024-13-40",
    "hello"
  ]
}