3 Replies Latest reply: Mar 15, 2018 9:12 AM by Sunny Talwar RSS

    Make a diffeerence 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

       

      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.