Script Error

[#1]

if([Status]<>'YES', or if([Status]<>'NO',

  if(Date([fuTureDate])- Date(Today())<90, 'Red')))

Am I doing anything wrong here ?

[sunny_talwar · Accepted solution]

I see an extra comma (,) before or and if clauseafter or

if([Status]<>'YES' or [Status]<>'NO',

if(Date([fuTureDate])- Date(Today())<90, 'Red')))

[sunny_talwar]

or may be this to simplify it:

=If(WildMatch(Status, 'YES', 'NO'), If(fuTureDate - Today() < 90, 'Red'))

=If(not WildMatch(Status, 'YES', 'NO'), If(fuTureDate - Today() < 90, 'Red'))

[qlikmsg4u]

=if([Status]<>'YES' or [Status]<>'NO', if(Date([OperativeBeginDate])- Date(Today())<90, 'Red'))