Compare dates transform action

Use case

You are building a workflow that checks if the tickets closed date is greater than the expected close date and would like to know if action is needed based on a true/false value.

Overview

This transform will take two dates and an operator, it will then perform a comparison based on the operator and return a boolean value.


Parameters

Parameter
Description
Required

First Date

This should be a valid datetime string representation.

Second Date

This should be a valid datetime string representation.

Comparison Operator

The operator to use in the comparison.

Day First

Whether to interpret the first value in an ambiguous 3-integer date (e.g. 01/05/09) as the day (True) or month (False). If yearfirst is set to True, this distinguishes between YDM and YMD. If set to None, this value is retrieved from the current parserinfo object (which itself defaults to False).

Fuzzy Parsing

Whether to allow fuzzy parsing, allowing for string like "Today is January 1, 2047 at 8:21:00AM"

Ignore Timezone

If set True, time zones in parsed strings are ignored and a timezone naive datetime object is returned.

Year First

Whether to interpret the first value in an ambiguous 3-integer date (e.g. 01/05/09) as the year. If True, the first number is taken to be the year, otherwise the last number is taken to be the year. If set to None, this value is retrieved from the current parserinfo object (which itself defaults to False).

Usage

Example 1: Greater Than

Inputs:First Date: 2025-03-13T04:00:00.000ZSecond Date: 2025-03-14T04:00:00.000ZComparison Operator: >Day First: NoneFuzzy Parsing: TrueIgnore Timezone: FalseYear First: None

Results output

The expected output for this transform is a boolean value based on the comparison of the two dates.

Result Output for Example 1:

False

Last updated

Was this helpful?