I am trying to change the display text of the status of a milestone task when it’s current due date is equal to the current date. The due date has a day and time, but I want the status to show “Due Today” the entire day it’s due, not just after the specific due date time.
I don’t need to change the status in the database for any purpose really, just to change the text on milestone task from “Upcoming” to “Due Today”. The day after the task is due the status will need to change to “Past Due”.
It seems straightforward, but I can’t get it to work. Maybe I need to do a backend workflow, which I don’t know how to do yet.
It is an option set already. I just can’t get the milestone due date to match the current date. The text resolves to “No” for some reason. I guess that means error?
Hey there, the date formatting is different, you need both the be formatted the same, like formatted at 12/12/12 , doesn’t matter which format, just has to be the same, otherwise they won’t match
Silly mistake, however it is still evaluating as No where it should say Due Today, so something is off. Could it be becuase it is not also matching the time? Should I extract day?
Due date equals rounded down to day:Current date time is all you need for the condition.
Your text expression is equal to Parent group's Milestone's Milestone-status is Due Today. That’s a yes/no statement, hence it will display yes or no. You need to display Parent group’s Milestone’s Milestone-status’ Display
