Nested IF formula involving greater than a fixed date

[#1]

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

[sunny_talwar · Accepted solution]

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]

[#3]

Great!! Thanks Sunny, it worked smoothly!!