Skip to main content
Picks the dated property at one or more moments — Today, Oldest, Latest, Latest defined, or Today or next 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, Today or next 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.
  • Use Today or next defined to catch joiners: someone whose first values start in the future has nothing active today, so Today returns nothing. This moment returns today’s value when there is one, and otherwise the next upcoming value that is actually set. Unlike Latest it stops at the first upcoming value, so a change planned further out does not win over the value the person starts with.
  • Pair with Match / Equals when filtering should look at the latest rather than today’s value.

​
Ports