Date&Time Range Creator

Generates sequences of date&time values based on defined parameters. You can create sequences using three modes: Duration & End (start, end, and interval), Number & End (number of rows, start, and end), or Number & Duration (number of rows, start, and interval).
Typically used to generate time series data for simulations, forecasts, or testing.

Options

Output type

The type to create can be selected. It can be either a Date, Time, Date&time (Local), or Date&time (Zoned).

• Date: Outputs values of type Date
• Time: Outputs values of type Time
• Date & time: Outputs values of type Date&time (Local)
• Date & time & zone: Outputs values of type Date&time (Zoned)

Start date

The date at which the date&time creation should start, inclusive.

Start time

The time at which the date&time creation should start, inclusive.

Start local date&time

The local date&time at which the date&time creation should start, inclusive.

Start zoned date&time

The zoned date&time at which the date&time creation should start, inclusive.

Use execution date & time

If checked, the execution date & time will be used as starting point.

Fixed steps

How the rows are created.

• Count to end: Outputs evenly spaced date&time rows, with the specified number of output values, starting at the the start date&time and ending exactly at the specified end date&time. The number of rows produced in this case is fixed to the number of steps specified.
• Count with interval: Outputs evenly spaced date&time rows, with the specified interval between them, starting at the start date&time and ending once the specified number of rows have been added. The number of rows produced in this case is fixed to the number of steps specified.
• Interval to end: Outputs evenly spaced date&time rows, with the specified interval between them, starting at the start date&time and ending at or before the end date&time, depending on whether the interval divides exactly into the range. The number of rows produced in this case is variable and depends on the interval and the range.

Number of rows

The number of rows to create.

Interval between rows

The interval between the created rows.

End date

The date at which the date&time creation should stop. The end date is inclusive, except if the output mode is 'Number and Duration' and the provided interval does not divide evenly between the start and end date.

End time

The time at which the date&time creation should stop. The end time is inclusive, except if the output mode is 'Number and Duration' and the provided interval does not divide evenly between the start and end time.

End local date&time

The local date&time at which the date&time creation should stop. The end date&time is inclusive, except if the output mode is 'Number and Duration' and the provided interval does not divide evenly between the start and end date&time.

End zoned date&time

The zoned date&time at which the date&time creation should stop. The end date&time is inclusive, except if the output mode is 'Number and Duration' and the provided interval does not divide evenly between the start and end date&time.

Use execution date & time

If checked, the execution date & time will be used as ending point.

Output column name

The name of the output column.

Views

This node has no views

Workflows

• No workflows found

Links

• No links available

Developers