Date

Input

value

Format value as a date from yyyy-MM-dd, MM/dd/yyyy (MM/dd/yyyy)

transformation:

date

Convert date between formats

source:value

parameters

outputFormat

Output date format (Luxon format string)

Output

value
01/15/2024
06/01/2024
12/31/2023
01/15/2024
Invalid Date
Invalid Date

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

Convert date between formats.

Parameters

• inputFormats (Accepted Date Formats, array, optional) — Array of input date formats to try (uses defaults if empty). Enter one format per line. Examples: ["MM/dd/yyyy"], ["yyyy-MM-dd","MM/dd/yyyy"], ["dd-MM-yyyy"].
• outputFormat (Output Format, string, optional) — Output date format (Luxon format string). Examples: "yyyy-MM-dd", "MM/dd/yyyy", "dd-MM-yyyy", "yyyy/MM/dd".

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": "transformation",
  "action": "date",
  "params": {
    "inputFormats": [
      "yyyy-MM-dd",
      "MM/dd/yyyy"
    ],
    "outputFormat": "MM/dd/yyyy"
  },
  "testInputs": [
    "2024-01-15",
    "2024-06-01",
    "2023-12-31",
    "01/15/2024",
    "invalid",
    ""
  ]
}