Question

I have a task database set-up and a formula to show if tasks are completed early, on time, or late. It's working fine for one-time tasks, but apparently not recognizing due dates that are set by recurring templates. Any ideas for how to fix this? Or procedures for asking to fix this glitch?

Comments

¿Which recurring templates?
¿How that works?
¿Which formula?

Without seeing exactly how you have everything, it is really difficult to guess. Please share the complete information to have a look.

---

I have a large number of repeating templates set up to automatically set a due date of "today" (which populates the Due Date field with the date on which it is created.) I use the following formula to populate a "Complete Status" field:

ifs(empty(prop("Due Date"))," ",prop("Date Completed")<prop("Due Date"),"Early",prop("Date Completed")==prop("Due Date"),"On Time",prop("Date Completed")>prop("Due Date"),"Late","**")

It works for tasks that I create individually, but any task created by a template yields "**" for any date completed. If I manually edit the Due Date (clear and reset), it works correctly.

After a bit of testing, I found that it correctly calculates early or late if I change the date completed. But doesn't show on time unless I manually edit the due date.

Answer 1

I tested it and you are correct.

If you do it by the minute, live and without waiting any second, it does not work.

You need to wait for it to work.

The template creates one now at 5:03 PM today, you set Completed at 5:05 PM today (to test) = Will Not Work.

Let it work 24 hrs, if it is created today at 5:03 PM, for sure you will not add a completed date at 5:05 PM.

So I believe that is the problem, that you are testing it as a live environment, when it is not, it needs time to work. (24 hrs or more)

Created today by template (no time means 0:00), then after 24 hrs you select an end date with no time as well.

Otherwise you will need to include time in the dates. In the template, in the completed date and in the formula, that way the exact minute can work live as you are testing.

If you are not doing it 3 minutes later to test and you are actually waiting more than 24 hours, then this can be a bug. I will keep my test running till tomorrow so the item is created and add a day later the completed date to see if the same happens.