8 Replies Latest reply: Mar 16, 2018 12:34 AM by Krishna Nagulapally RSS

    How to show difference between two date fields

    ravi kumar

      Hi,

      I have a two fields NR, IRB.

      1. NR>30 DAYS to IRB Date ,   required result:Processing, Late Payment.
      2. NR<30 DAYS to IRB Date ,   required result: on time payment.
      3. when  to IRB Date is value: '-' ,    required result: Processing.
      4. NR we will calculate based on system date required, entered more than system date required result: entered wrong date.

      note: I required all these expressions in set analysis only.

      1. I'm tried for this :

      If([IRB] = '-', 'Processing',


           If([IRB]- [PaymentDate NR] < 30, 'On Time Payment', 'Late Payment'))

      ** i want to convert if() into set analysis**

      NRIRB
      10-Jan-1713-Jan-17
      26-Jan-1702-Feb-17
      31-jan-1710-feb-17
      20-feb-175-apr-17
      5-feb-17-
      10-mar-175-jun-17
      5-apr-17-

       

      Advance Thanks,

      Ravi.