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

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
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.
Photo of Nenad Ilic

Nenad Ilic

  • 734 Points 500 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of dwhawe

dwhawe, Champion

  • 876 Points 500 badge 2x thumb
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])
(Edited)
Photo of Nenad Ilic

Nenad Ilic

  • 734 Points 500 badge 2x thumb
This is a good option, but the idea behind is:
* I have start date and end date, but I don't know when the end date will be (in case of delays)
* so my duration counter is working based on delays as each day passes I can see that delay duration is prolonging, and that it is not affecting project aging (due to delay that was encountered).

If I use two fields, I might not be able to track it properly. 

I was also thinking if there is a possibility of using yuor formula-date field, in combination with checkbox field, so when the checkbox is checked, the delay is closed.....

somehow to combine:
 If [checkbox] is unchecked, If(IsNull([Input End Date]),Today(),[Input End Date])
If [checkbox] is checked, enterdate


Do you think this solution might be achievable?
Photo of Kingsly SD Samuel

Kingsly SD Samuel

  • 776 Points 500 badge 2x thumb
Will it help if you use the native solution of selecting "default date" to "today" on the "field settings" - just wondering!
Photo of dwhawe

dwhawe, Champion

  • 876 Points 500 badge 2x thumb
The formula field is native.  Also the default setting set the value when the record is created but does not remain the current date when the record is opened on future dates
Photo of Nenad Ilic

Nenad Ilic

  • 734 Points 500 badge 2x thumb
Yup, I thought that the formula will autoupdate the field for today, but realized that it is only for the date of creation.