Skip to content
Back to

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

  • params.source — Field whose values this operation reads. Use a single field name, a comma-separated list of plain field paths (cash_flow_type, currency) from the multi-select UI, or a regex via Pattern mode. Omit to apply to all fields on the row.
  • params.target — Optional output field. When omitted, the source field is updated in place. Hidden when more than one named source field is selected.

JSON Configuration

{
  "id": "op-date",
  "kind": "transformation:date",
  "params": {
    "inputFormats": [
      "yyyy-MM-dd",
      "MM/dd/yyyy"
    ],
    "outputFormat": "MM/dd/yyyy"
  }
}