Forum Discussion

ReneeHansen's avatar
ReneeHansen
Qrew Member
3 years ago

Duration Formula Help

Hi, 
I have a duration formula to calculate the number of days from First Production Date to First Payment date

but I would like it to show how many days have passed as well.

how would I write that?



------------------------------
Renee Hansen
------------------------------

Formulas and functions

1 Reply

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    var date EndDate = IF(IsNull([First Payment date]), Today(), [First Payment date]);

    $EndDate - [First Production date]

    //  assume what you're asking for is to show the running clock of the last days if the payment has not yet been made.  I'm also assuming in this formula that the payment date is after the production date.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------