Skip to main content

Datetime operators

is before

"is before" operator works by checking if the value on the left-hand side is "before" the value on the right-hand side.

is before

For example, in the screenshot above, the condition will match if order creation time is before "30 days ago relative to current time" i.e, where order creation time is more than 30 days old.

is after

"is after" operator works by checking if the value on the left-hand side is "after" the value on the right-hand side.

is after

For example, in the screenshot above, the condition will match if order creation time is after "30 days ago relative to current time" i.e, the order is created in the last 30 days.

Specifying DateTime value​

When specifying the date and time in the condition, you could use relative date-time or absolute date time.

Relative

You could use relative dates like -- "30 minutes ago", "2 weeks ago", "1 month ago", "3 months ago", "in 2 days", "tomorrow". It works by calculating the absolute time by manipulating the current time.

For example, if you specify "30 days ago", it will translate to "current system time - 30 days". So whenever the workflow is executed we'll first calculate the current system time and then apply the relative date specified.

Absolute

Instead of using relative dates, you can also specify the absolute date as follows:

  • Just the date: You can simply mention the date in either of the formats i.e, YYYY/MM/DD or MM/DD/YYYY
  • Date and time: To be more specific with your conditions, you can specify the time along with the date. For example 2021/01/09 00:04:00
  • DateTime with Timezone: For example 28/05/2021 09:00:00 -0700, If the timezone is not specified, the uses the UTC timezone by default.