ContributionsMost RecentMost LikesSolutionsRe: How can I get days overdue to stop revving without setting the value to nullthank you so very much for your help. Changing the formula type resolve the issue with the formula you passed. Never would have thought of that. thanks again.Re: How can I get days overdue to stop revving without setting the value to nulllooks like I might have the incorrect formula type. I just changed it to formula Numeric and things appear to be working. I Just need to run a few more test to validate.Re: How can I get days overdue to stop revving without setting the value to nullDays Overdue is a Duration Formula Status is set to DeliveredRe: How can I get days overdue to stop revving without setting the value to nullActual Finish Date = 4-24-19 Calculated Finish Date = 4-19-2019 so I would expect day overdue to be 5Re: How can I get days overdue to stop revving without setting the value to null this is the results from my original formula If([Status] = "Delivered", null, ToDays(Today() - ToDate([Calculated Finish Date])) <= 0, null, Today() - ToDate([Calculated Finish Date])) Initial task shows status �In Process� with days overdue being equal to 7 If I set the status to delivered, the days overdue field becomes Null When I add in your formula to Days Overdue (I get the warning I specified, but the formula does save) If( [Status] = "Delivered" and [Actual Finish Date] >= ToDate([Calculated Finish Date]), ToDays([Actual Finish Date] - ToDate([Calculated Finish Date])), Max(0, ToDays(Today() - ToDate([Calculated Finish Date])))) All Days Overdue turn to null If I set the status to Delivered, the Days Overdue is still null I want to see days overdue for any status and once marked delivered, stop increasing the date Re: How can I get days overdue to stop revving without setting the value to nullthe formula is saved. the days overdue value is wiped out. here is a clean scenario on a app that you could walk through to see what I am referring to: if you download the following app under sample app: Dynamic Dashboard by Bill Marshall 24 May 17and look at any task that is marked overdue. I will used the ROI assessment task with the start date of 4-23-2015 for example: This shows the task being 1458 days overdue. If I change the status to Completed, the overdue date gets wiped out. (This was my original formula) I would like to keep the # of days overdue so I can obtain metrics on how we did meeting deadlines. I tried implementing the following formula which does not wipe out this value in days overdue, however the number of days keeps incrementing ever day. How can I get the Days Overdue entry to stop incrementing once the status is marked completed? If(ToDays(Today() - ToDate([Calculated Finish Date])) <= 0, null, Today() - ToDate([Calculated Finish Date])) Re: How can I get days overdue to stop revving without setting the value to null Used what you suggested except Date Delivered is Actual Finish Date. If( [Status] = "Delivered" and [Actual Finish Date] >= ToDate([Calculated Finish Date]), ToDays([Actual Finish Date] - ToDate([Calculated Finish Date])), Max(0, ToDays(Today() - ToDate([Calculated Finish Date])))) The line: ToDays([Actual Finish Date] - ToDate([Calculated Finish Date])), give me the warning of �Expecting Duration but found number� Re: How can I get days overdue to stop revving without setting the value to nullI added in a new Date Field "Date Delivered" and set the form action to set the date to date status was changed to Deliver. I than added in the formula specified to the field "Days Overdue". I now get the error "Expecting duration but found number" and the days overdue field end up being empty. the field Date Delivered is a date field, and Calculated Finish Date is a formula-Work Date field How can I get days overdue to stop revving without setting the value to null I am currently using the following formula which captures the days overdue within the formula field ?Days Overdue? while the status is not equal to Delivered. I would like to be able to set the status to Delivered and not reset the ?Days Overdue? field to null. I also want to ensure that the ?Days Overdue? field stops counting so I have a record of the exact number of days the task was overdue so it can be reported. Current working formula: If([Status] = "Delivered", null, ToDays(Today() - ToDate([Calculated Finish Date])) <= 0, null, Today() - ToDate([Calculated Finish Date])) For example: Status = In Process with a the Calculated Finish Date of 4-19-2019. This displays 4 days overdue. If I set Status = Delivered, I would like to keep the current value in Days Overdue field (4) and would expect if I logged in the next day that the Days Overdue value remains at 4. Any help would be appreciated. Re: Combine two applications tables into single dashboard or reportthank you very much. This is a much easier method then were I was going. Everything is working beautifully,