3 Replies Latest reply: Oct 9, 2015 10:26 AM by Nagaraj Shanmugam RSS

    Need help on calculating no. days between 2 dates

    Nagaraj Shanmugam

      I'm trying to calculate avg Lead Time . Lead Close date - Lead State Date = Yield time.  This formula works in QV and not in QS. Can some help .


      avg((Ceil(Interval(Date#(CLOSEDATE, 'MM/DD/YYYY hh:mm:ss TTT') - Date#(STAGEDATE, 'YYYY/MM/DD'), 'DD' )) ))