IsBefore

The IsBefore formula function returns a Boolean value.

An IsBefore (Filter) function works similarly but instead of returning a Boolean value, allows records which are true to pass on within the Flow.

Description

Checks if the argument's field dates come before another argument's field dates or a constant date. If the first argument's date value comes before the second argument's date value, a true Boolean value is returned. If the first argument's date value does not come before the second argument's date value, a false Boolean value is returned. A new column is created for the results.

Dynamic Date Guide

Supported Function

FunctionDescription
now()Use the function "now()" as a dynamic date that sets the time/date value to Hero Platform_'s internal clock value when the Flow is run.


Supported operators

Operator symbolDescription
+Adds to the date/time value based on the date/time unit entered.
-Subtracts from the date/time value based on the date/time unit entered.


Supported temporal units

Time/Date unit symbolDescription
sSeconds
minMinutes
hHours
dDays
wWeeks
mMonths
yYears

Use

  • Date:
    • Select an argument (Date), constant, or dynamic date.
  • Before:
    • Select a second argument (Date), constant, or dynamic date.
  • Enter an output field name.

Type

Formulas