U_Date_Calculator

Tarih hesaplama ve manipülasyon işlemleri

U_Date_Calculator

AI-generated

Summary

Calculate and output BeginDate and EndDate fields based on configurable date calculation methods and parameters, supporting two modes: mode-based calendar calculations or field-based custom date computations.

Inputs

  • Operation Mode (required) — Select between 'beginEnd' mode for predefined BeginDate and EndDate calculations or 'fieldBased' mode for custom field-named date calculations.
  • BeginDate Method (beginEnd mode) (required) — Method to calculate the BeginDate such as month start, today, relative day, etc.
  • BeginDate Params (beginEnd mode) (required) — Key-value parameters to modify the BeginDate calculation, e.g., day, month_offset, year_offset.
  • EndDate Method (beginEnd mode) (required) — Method to calculate the EndDate with options including relative day, month end, quarter end, etc.
  • EndDate Params (beginEnd mode) (required) — Key-value parameters to modify the EndDate calculation.
  • Output Format (beginEnd mode) (required) — Select output date format such as yyyy-MM-dd or dd/MM/yyyy.
  • BeginDate Field Name (fieldBased mode) (required) — Name of the output field for BeginDate.
  • BeginDate Length (fieldBased mode) — Length to pad or truncate the BeginDate output string.
  • BeginDate Method (fieldBased mode) (required) — Calculation method string to derive BeginDate in field-based mode, e.g. 'gecen_ay_26'.
  • BeginDate Output Type (fieldBased mode) (required) — Date format for the BeginDate output in field-based mode.
  • EndDate Field Name (fieldBased mode) (required) — Name of the output field for EndDate.
  • EndDate Length (fieldBased mode) — Length to pad or truncate the EndDate output string.
  • EndDate Method (fieldBased mode) (required) — Calculation method string to derive EndDate in field-based mode.
  • EndDate Output Type (fieldBased mode) (required) — Date format for the EndDate output in field-based mode.

Output shape

a list of JSON objects with new date fields added to each input item

Each output item JSON includes calculated BeginDate and EndDate fields, along with optional start and end range timestamps (e.g., BeginDate_start, EndDate_end) when relevant. Field names and formats depend on selected mode and parameters. Errors per item are returned in a structured error JSON if continueOnFail is enabled.

Examples

Example 1: Calculate BeginDate as the 26th day of the current month and EndDate as the relative day with zero offset, outputting dates in yyyy-MM-dd format.

Set Operation Mode to 'BeginDate & EndDate', BeginDate Method to 'bu_ay_X' with day=26 parameter, EndDate Method to 'relative_day' with offset=0, and Output Format to 'yyyy-MM-dd'. The node outputs these two date fields added to each input item.

Discussion