is it possible to create active day counter, (for date to automatically update to today) until the date is selected

Question

I'm trying to create a delay counter that works on the following principle:
1. we have a start date
2. end date

In a situation we enter the starting date for delay, but don't know how long will the delay last.
So I would need for "end date" to automatically update for "today" until we select that the delay is officially closed.

Example:
1. today my delay starts so I enter 7/19/2017
2. my end date is set by default for today, thus it is also 7/19/2017, but each other day that I visit the statuses, the date automatically changes to that day (on Friday it shows 7/21/2017, Monday 7/24/2017 etc) but the moment I select a date the date is closed.

DavidHawe · Answer

There may be better solutions but I would do it like this:

Two fields for the end date. "End Date" which is a formula-date field and the field you use in reports and duration calculations and "Input End Date" to input the date when you have an actual end date.

The formula for "End Date"

If(IsNull([Input End Date]),Today(),[Input End Date])

Sign up

Login to the community