Skip to main content
Picks the dated property at one or more moments — Today, Oldest, Latest, or Latest defined — from a stream of dated properties. Sibling of At Date (always picks by an explicit date) and At Index (picks by position).

Inputs

  • Data / default in — the dated properties to pick from.
  • Date — optional. When wired, picks at that exact date and ignores the As-of moments setting.

Configuration

  • As-of moments — pick any non-empty subset of Today, Oldest, Latest, Latest defined. The node emits the dated property at every selected moment (deduplicated by id + valid_from).
  • Use loop date — shown only inside a loop, on by default. While on, the node uses each iteration’s date and the As-of moments are ignored. Turn it off to pin the node to the As-of moments above even inside a loop.

Tips

  • Use Latest when you want the most recent value regardless of whether it is active today (mirrors the legacy get_by_date default).
  • Use Latest defined when Latest and Today would return nothing because the newest segment is empty — e.g. an employee with a future termination, or one who has not started yet. Latest defined skips those empty segments and returns the most recent segment that actually has a value set.
  • Pair with Match / Equals when filtering should look at the latest rather than today’s value.

Ports