Time comparisons

Back to: Index of transforms

Transforms in this section compare a time data type. These comparison transforms are useful for filtering transform table rows by time columns. These comparison transforms can also be used separately outside of transform tables. Learn more about how to search for and add a transformation.

• Before
• On or before
• After
• On or after
• Between (inclusive)
• On
• Not on

Before

Returns True if the input timestamp is before the second timestamp.

On or before

Returns True if the input timestamp is on or before the second timestamp

After

Returns True if the input timestamp is after the second timestamp.

On or after

Returns True if the input timestamp is on or after the second timestamp.

Between (inclusive)

Returns True if the input timestamp is inclusively between the second and third timestamp.

On

Returns True if the input timestamp is on the second timestamp.

Not on

Returns True if the input timestamp is not on the second timestamp.