IsAfter
The IsAfter formula function returns a Boolean value.
An IsAfter (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 after another argument's field dates, a constant date, or a dynamic date.. If the first argument's date value comes after the second argument's date value, a true Boolean value is returned. If the first argument's date value does not come after the second argument's date value, a false Boolean value is returned. A new column is created for the results.
Argument date:
- A stored tuple value.
Constant date:
- A specific date/time value.
Dynamic date:
- A variable date/time value created with functions and/or operator symbols.
Dynamic Date Guide
Supported Function
| Function | Description |
|---|---|
| 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 symbol | Description |
|---|---|
| + | 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 symbol | Description |
|---|---|
| s | Seconds |
| min | Minutes |
| h | Hours |
| d | Days |
| w | Weeks |
| m | Months |
| y | Years |
Example
The goal is to use IsAfter to filter results with date values that are within the past five minutes from the current time.
- Select the IsAfter filter function.
- In the function configuration:
- Select a date/time value in the first field.
- Enter "now() -5min" in the second field.
- Click OK.
Use
- Date:
- Select an argument (Date), constant, or dynamic date.
- After:
- Select a second argument (Date), constant, or dynamic date.
- Enter an output field name.
Hero Platform_ Example
An example of this function can be found in Hero Platform_'s library of examples.
Download the example titled "function_IsAfter" to see an example of this function.
