Skip to main content

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}?



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


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.


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.


Ah, I missed that part.


Then yes you need to have it as an IF Statement


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.



I’m just not sure how to do that 😕


Reply