# How do date triggers work in rules? (Title changed) **URL:** \ **Category:** Ask the Community\ **Tags:** dates, rules, agentic-work-management\ **Created:** [19 February 2026 02:46 UTC](https://forum.asana.com/t/how-do-date-triggers-work-in-rules-title-changed/1126342 "2026-02-19T02:46:44Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![ka\_nishiyama](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/ka_nishiyama/32/292165_2.png) [@ka\_nishiyama](https://forum.asana.com/u/ka_nishiyama)\ **Post date:** [19 February 2026 02:46 UTC](https://forum.asana.com/t/how-do-date-triggers-work-in-rules-title-changed/1126342/1 "2026-02-19T02:46:44Z")
If I set the trigger for a rule to “Task is overdue” will the rule not work on completed tasks? For example, I set up a process to delete a task from the project a specified number of days (e.g., 3 days) after completion, but it doesn’t seem to be executed. If rules can’t be applied to completed tasks, are there any alternatives? * * * Currently, it doesn’t seem to be triggered on completed tasks. I think it’s necessary for Multi-home feature of asana. > [@Allow "Task is Overdue" trigger to work for completed tasks](https://forum.asana.com/t/allow-task-is-overdue-trigger-to-work-for-completed-tasks/170119): > > Currently, in Rules within the Triggers menu under the “Task Timing” section there are only three types of triggers: Task is no longer blocked, Due Date is approaching, and Task is overdue. The request is to add a fourth trigger type for “Task is completed.” The requested “Task is Completed” trigger would allow you to trigger a rule after X period of time from the date/timestamp of a task being completed. The existing trigger for “Tasks is overdue” only functions for incomplete tasks, so it can… ---
**Author:** ![Richard\_Sather](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/richard_sather/32/276096_2.png) [@Richard\_Sather](https://forum.asana.com/u/Richard_Sather)\ **Post date:** [19 February 2026 04:48 UTC](https://forum.asana.com/t/how-do-date-triggers-work-in-rules-title-changed/1126342/2 "2026-02-19T04:48:05Z")
> [@ka\_nishiyama](#): > > I set up a process to delete a task from the project a specified number of days Hi @ka_nishiyama , there isn’t a rule action to delete a task. Perhaps you mean to remove the task from a project? And, no, the ‘when overdue’ trigger will not run on completed tasks because the task is no longer regarded as overdue since it is completed. However, I can understand your use case, although I’ve never come across this need with any of the numerous customers we’ve worked with. ---
**Author:** ![Richard\_Sather](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/richard_sather/32/276096_2.png) [@Richard\_Sather](https://forum.asana.com/u/Richard_Sather)\ **Post date:** [19 February 2026 04:56 UTC](https://forum.asana.com/t/how-do-date-triggers-work-in-rules-title-changed/1126342/3 "2026-02-19T04:56:17Z")
Actually, @ka_nishiyama, you could try creating a formula field A that is (Completed date +3 days, for example) and then another formula field B that is (Formula A - Today). Then you could create a rule trigger when Formula B is changed and Number is equal to 0, then run your action. I haven’t tried this but it should work in theory, although I’ve ran into some bugs when triggering formula number fields.. > [@beetle Rules not triggering when 'Number is' condition is a formula field](https://forum.asana.com/t/rules-not-triggering-when-number-is-condition-is-a-formula-field/1075875): > > [@Forum-team](https://forum.asana.com/groups/forum-team) , I kindly ask that you escalate this issue to the product team to have a look - this one is definitely in the ‘not expected behaviour’ category grimacing Not sure whether the introduction of (the very useful) formatting feature within formulas has caused this to break, or it was always the case but I will try and explain as best as possible in order for you to recreate, test, and hopefully fix since the use cases are numerous! folded_hands One use case is to set a single-selec… ---
**Author:** ![ka\_nishiyama](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/ka_nishiyama/32/292165_2.png) [@ka\_nishiyama](https://forum.asana.com/u/ka_nishiyama)\ **Post date:** [19 February 2026 11:14 UTC](https://forum.asana.com/t/how-do-date-triggers-work-in-rules-title-changed/1126342/4 "2026-02-19T11:14:11Z")
Hi @Richard_Sather I’m considering the following behavior. Base Project - Project A: Tasks A1-A50 - Project B: Tasks B1-B50 Project C: Displaying tasks within a specified period - Displaying tasks from 3 days before to 3 days after today’s date - Tasks can be completed or incomplete. Task manipulation based on rules - Multi-home from Projects A and B to C based on the due date - Delete overdue tasks from C. ---
**Author:** ![ka\_nishiyama](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/ka_nishiyama/32/292165_2.png) [@ka\_nishiyama](https://forum.asana.com/u/ka_nishiyama)\ **Post date:** [19 February 2026 12:09 UTC](https://forum.asana.com/t/how-do-date-triggers-work-in-rules-title-changed/1126342/5 "2026-02-19T12:09:09Z")
> [@Richard\_Sather](#): > > Completed date +3 days, fo Cannot execute “creating a formula field A that is (Completed date +3 days)”. ![image](https://us1.discourse-cdn.com/asana/original/4X/a/0/d/a0d38941c232073ba6639cd383277092b747bf7d.png) ---
**Author:** ![Richard\_Sather](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/richard_sather/32/276096_2.png) [@Richard\_Sather](https://forum.asana.com/u/Richard_Sather)\ **Post date:** [19 February 2026 14:49 UTC](https://forum.asana.com/t/how-do-date-triggers-work-in-rules-title-changed/1126342/6 "2026-02-19T14:49:04Z")
You need to use the DateAdd function 😉 ![image](https://us1.discourse-cdn.com/asana/original/4X/4/a/3/4a38b3b627b852225a8dc6d9d412f8469ad0a9d9.png) ---
**Author:** ![ka\_nishiyama](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/ka_nishiyama/32/292165_2.png) [@ka\_nishiyama](https://forum.asana.com/u/ka_nishiyama)\ **Post date:** [19 February 2026 20:32 UTC](https://forum.asana.com/t/how-do-date-triggers-work-in-rules-title-changed/1126342/7 "2026-02-19T20:32:54Z")
An error occurs and you cannot proceed. _The output of a formula cannot change from a date to number, or vice versa. Please create a new formula._ ![image](https://us1.discourse-cdn.com/asana/original/4X/0/d/f/0df97dc9b6e15d1da044e8acd2428f6c4f59a2b0.png) ---
**Author:** ![Richard\_Sather](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/richard_sather/32/276096_2.png) [@Richard\_Sather](https://forum.asana.com/u/Richard_Sather)\ **Post date:** [20 February 2026 07:59 UTC](https://forum.asana.com/t/how-do-date-triggers-work-in-rules-title-changed/1126342/8 "2026-02-20T07:59:42Z")
Yes, this is expected, you cannot modify an existing one. Did you try creating a new formula from scratch? ---
**Author:** ![ka\_nishiyama](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/ka_nishiyama/32/292165_2.png) [@ka\_nishiyama](https://forum.asana.com/u/ka_nishiyama)\ **Post date:** [11 March 2026 07:46 UTC](https://forum.asana.com/t/how-do-date-triggers-work-in-rules-title-changed/1126342/9 "2026-03-11T07:46:05Z")
@anon58784865 , thank you for the information. I tested rule execution using due dates and date (field types). This is the current rule execution status (Asana’s features are constantly changing, so this is the current status). Therefore, I changed the title. 1 For due dates - Timing: When changed, Rule execution: Execute tasks = OK, Completed tasks = OK - Timing: When approaching, Rule execution: Execute tasks = OK, **Completed tasks = NG** - Timing: When overdue, Rule execution: Execute tasks = OK, **Completed tasks = NG** 2 For date fields - Timing: When changed, Rule execution: Execute tasks = OK, Completed tasks = OK - Timing: When approaching, Rule execution: Execute tasks = OK, Completed tasks = OK - Timing: When overdue, Rule execution: Execute tasks = OK, Completed tasks = OK ---
**Author:** ![ka\_nishiyama](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/ka_nishiyama/32/292165_2.png) [@ka\_nishiyama](https://forum.asana.com/u/ka_nishiyama)\ **Post date:** [10 April 2026 07:46 UTC](https://forum.asana.com/t/how-do-date-triggers-work-in-rules-title-changed/1126342/10 "2026-04-10T07:46:09Z")
Closed on 10 April 2026 07:46 UTC This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.