IIF expression with datediff

• vasanti mestri

  Right there with Babe

  Points: 786

  More actions

  February 18, 2011 at 6:29 am

  #388892

  Hi guys,

  cn anybody tell me why this is not working..pls pls help me ..its urgent...

  iif(Fields!attend_edate.Value <> nothing and Fields!completedur.Value is nothing,datediff("dd",Fields!attend_sdate.Value,Fields!attend_edate.Value),Fields!completedur.Value)

• Daniel Bowlin

  SSC-Dedicated

  Points: 34566

  More actions

  February 18, 2011 at 7:45 am

  #1288856

  vasanti mestri (2/18/2011)

  ---

  Hi guys,

  cn anybody tell me why this is not working..pls pls help me ..its urgent...

  iif(Fields!attend_edate.Value <> nothing and Fields!completedur.Value is nothing,datediff("dd",Fields!attend_sdate.Value,Fields!attend_edate.Value),Fields!completedur.Value)

  I have never been able to use an "And" in an IIF expression, instead you should nest it further into your expression.

  iif(Fields!attend_edate.Value <> nothing,IIF(Fields!completedur.Value is nothing),datediff("dd",Fields!attend_sdate.Value,Fields!attend_edate.Value),Fields!completedur.Value),Fields!completedur.Value)

• bulbanos

  Ten Centuries

  Points: 1049

  More actions

  February 22, 2011 at 8:15 am

  #1289876

  Try

  iif(IsNothing(Fields!attend_edate.Value)=1 AND ...)

  Using AND does work correctly

  ---

  
  My LinkedIn profile

• vasanti mestri

  Right there with Babe

  Points: 786

  More actions

  February 22, 2011 at 9:09 pm

  #1290214

  Thnks u guys for ur quick resopnces....