How to - Conditions [automations]

Hey guys,

As per this question and problem Extracting records from one table to another based on dates - #2 by Kamille_Parks

How can I, and is it even possible to choose Condition where {date field} is is/on or after/exact date/etc. as {another date field from table}?

image

Because the only option I have is to choose specific date.
image

Long story short, I need to trigger certain automation with record that has its unique date field (lets call it {date1}), but that automation needs to be triggered only when that record’s date ({date1}) is in a certain specific range I choose (lets call it {date2} & {date3} because I actually have FROM and TO fields to make that specific range).

Thanks

Hi @Michael1 ,

See the “is” part? This is where you will find the “is on or before” condition

However, @Michael1 is looking for dynamic input for the date ranges. That can’t be done with automations, so Michael, you’ll need to create formulas in your table to use as your conditions.

1 Like

Ah, I missed that part.

Then yes you need to have it as an IF Statement

I’m just not sure how to do that :confused: