Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a two fields NR, IRB.
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.
May be this
If(IRB = '-', 'Processing',
If(IRB - NR < 30, 'Processing', 'Late Payment'))
Hi,
here in your table, IRB is always > to NR dates..
so maybe change the condition of 1 to this:
I'm I wrong ?
if(isnull(ISB),'Processing',
if(IRB-NR<=30,'Processing','Late Payment')) as Whatever