← All features

Canvas nodes

Date Filter

Keep or exclude rows by relative dates, fixed ranges, or a date boundary.

How it works

Choose a date field and set a relative window, a fixed range, or a before or after boundary. You can keep the window or exclude it.

Click Date Filter on Canvas, then change Date in the inspector. Only orders after the cutoff appear in the output.

Simple example

Select Order Date in Date Filter, choose Relative mode, and select the last 30 days. The node passes orders in that window to the next step.

Date Filter selected in n0is Canvas in the simple example.
n0is Canvas · Sample dataView full size

Input

First 5 of 6 rows
Order IDOrder DateAmount
A1012026-09-21140
A1022026-10-0685
A1032026-10-19220
A1042026-10-3038
A1052026-11-06126

Node output

4 rows
Order IDOrder DateAmount
A1032026-10-19220
A1042026-10-3038
A1052026-11-06126
A1062026-11-0899

Complex workflow

A set of orders includes a migration period you want to exclude from a trend. Set Mode to Range, enter both boundary dates, and enable Exclude the window instead. Send the remaining rows to your chart workflow.

Date Filter selected in n0is Canvas in the complex workflow.
n0is Canvas · Sample dataView full size

Input

First 5 of 6 rows
Order IDRegionAmountStatusCustomer IDReference
A101West140ShippedC1Retail
A102East85PendingC2Outlet
A103West220ShippedC3Retail
A104North38CancelledC9Retail
A105East126ShippedC2Outlet

Node output

5 rows
Order IDRegionAmountStatusCustomer IDReference
A102East85PendingC2Outlet
A103West220ShippedC3Retail
A104North38CancelledC9Retail
A105East126ShippedC2Outlet
A106West99PendingC1Retail