Make a diffeerence between two date fields

[ravikumar_iyana]

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

NR	IRB
10-Jan-17	13-Jan-17
26-Jan-17	02-Feb-17
31-jan-17	10-feb-17
20-feb-17	5-apr-17
5-feb-17	-
10-mar-17	5-jun-17
5-apr-17	-

Advance Thanks,

Ravi.

[sunny_talwar]

May be this

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

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

[YoussefBelloum]

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]

if(isnull(ISB),'Processing',

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