Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
ravikumar_iyana
Creator
Creator

Make a diffeerence between two date fields

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.

3 Replies
sunny_talwar

May be this

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

     If(IRB - NR < 30, 'Processing', 'Late Payment'))

YoussefBelloum
Champion
Champion

Hi,

here in your table, IRB is always > to NR dates..

so maybe change the condition of 1 to this:

  1. IRB>30 DAYS to NR Date ,   required result: Late Payment

I'm I wrong ?

m_woolf
Master II
Master II

if(isnull(ISB),'Processing',

     if(IRB-NR<=30,'Processing','Late Payment')) as Whatever