Forum Discussion

NenadIlic's avatar
NenadIlic
Qrew Assistant Captain
8 years ago

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

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.
  • 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])
    • NenadIlic's avatar
      NenadIlic
      Qrew Assistant Captain
      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?
  • KingslySamuel1's avatar
    KingslySamuel1
    Qrew Assistant Captain
    Will it help if you use the native solution of selecting "default date" to "today" on the "field settings" - just wondering!
    • DavidHawe's avatar
      DavidHawe
      Qrew Trainee
      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
    • NenadIlic's avatar
      NenadIlic
      Qrew Assistant Captain
      Yup, I thought that the formula will autoupdate the field for today, but realized that it is only for the date of creation.