In another question (posted here), I mentioned that I had a question regarding dates in Automations, specifically date triggers in Automations. From what I can tell, you can't set a condition in an Automation trigger when a date field, or date value in a formula, changes. It seems the options are:
Is
Is not
Less than
Is after
Is on or before
Is on or after
Is empty
Is not empty
This seems to be related to the date value versus date string I mentioned in the post, linked above.
Is there something I'm missing? My only thought at the moment for a workaround is to have 2 fields. One field to set the condition for the trigger and another to specify the date value. This is not ideal.
Any thoughts or help is appreciated.
Thanks.