Forum Discussion

ReneeHansen's avatar
Qrew Member
3 years ago

Duration Formula Help

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

1 Reply

  • 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)