Compare dates transform action

Compare Dates

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