Run Automations Within a Date Range or Up to a Dynamic Date
future
J
Joseph Plaizier
It would be wonderful if there were automation options to trigger when the Current Date is within a date range before or after a custom field. There is the option, currently, to set triggers to run "at least" before and after a specific custom field, but it would be great if there was an option if it performed the inverse of what these options currently allow. I have attached some screenshots of where the current option will trigger for the "at least before" and "at least after".
Perhaps our use case will help explain further. We track passport expiration data for our employees because they do a lot of traveling and we don't want any last minute issues with their passports. We want to set up a reminder system so that when the passport hits the '1-year from expiration' point it will let the person know. With the current options available for the Current Date, this is not possible.
Hopefully all of this makes sense.
Log In
Zach - ClickUp
marked this post as
future
Zach - ClickUp
The inverse of 'at least X days before' is the piece that's missing. You've nailed why it matters — passport expiration is a perfect case where you need to catch something
within
a window, not just before
it. That range-based date trigger would unlock a ton of deadline-aware workflows: contracts, certifications, renewals. Really clearly scoped, thanks for the passport example specifically.