Discussions

Expand all | Collapse all

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

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

    Posted 07-19-2017 11:08
    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.


  • 2.  RE: is it possible to create active day counter, (for date to automatically update to today) until the date is selected

    Posted 07-19-2017 17:32
    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])


  • 3.  RE: is it possible to create active day counter, (for date to automatically update to today) until the date is selected

    Posted 07-20-2017 07:41
    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?


  • 4.  RE: is it possible to create active day counter, (for date to automatically update to today) until the date is selected

    Posted 07-19-2017 17:59
    Will it help if you use the native solution of selecting "default date" to "today" on the "field settings" - just wondering!


  • 5.  RE: is it possible to create active day counter, (for date to automatically update to today) until the date is selected

    Posted 07-19-2017 18:25
    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


  • 6.  RE: is it possible to create active day counter, (for date to automatically update to today) until the date is selected

    Posted 07-20-2017 07:32
    Yup, I thought that the formula will autoupdate the field for today, but realized that it is only for the date of creation.