2 Replies Latest reply: Oct 5, 2016 10:10 AM by Rafael Souza RSS

    Calculation Between Two Dates Expression

    Rafael Souza

      Staff, Good evening,

      I have a table:


      I'm riding a PivotTable that need to have a field that Count how many contracts meet the following criteries:

      • ((CodStatusBx = 0))
      • Diference apart from days (Current Date - Date Contract) greater than 10 calendar days

      This expression is not working for me
      Count({$<CodStatusBx={0}>} fabs(Date(Today(),'DD/MM/YYYY')) - fabs(Date(DtContrato,'DD/MM/YYYY')))

      Could help me?