Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I am trying to write an expression in Edit Script and facing issues with it. This expression is as follows -
if([POLICYSTATUS]='Inf' and [DOC]>>31/01/2014,'NB',IF([POLICYSTATUS]='Inf' and not [DOC]>>31/01/2014,'RB','Lapsed')) as [NB/RB]
I think I am making some mistakes either in writing IF formula or date expression is wrong.
Can anyone please help me in this regard.
Thanks!
Abhik
Try this:
If([POLICYSTATUS] = 'Inf' and [DOC] > MakeDate(2014, 1, 31), 'NB',
If([POLICYSTATUS] = 'Inf' and [DOC] <= MakeDate(2014, 1, 31), 'RB', 'Lapsed')) as [NB/RB]
Try this:
If([POLICYSTATUS] = 'Inf' and [DOC] > MakeDate(2014, 1, 31), 'NB',
If([POLICYSTATUS] = 'Inf' and [DOC] <= MakeDate(2014, 1, 31), 'RB', 'Lapsed')) as [NB/RB]
Great!! Thanks Sunny, it worked smoothly!!