Forum Discussion

RubenTarango's avatar
RubenTarango
Qrew Member
5 years ago

Formula

I am trying to create a formula for length of time it takes to correct an item, I would like answer in days.

Date corrected - Date Found, 
If Date corrected is blank, then todays date - date problem found.
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    np,
    I will first us a formula variable to calculate the end date to use.

    var date EndDate = IF(not isnull([Date corrected]), [Date corrected], Today());

    [Date Corrected] - $EndDate)



    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------