Post reply

Issue with IIf expression

  • October 13, 2011 at 9:06 am

    #245321

    I'm new to all this so I apologize in advance.

    I have the expression =IIf(Fields!COMPDATE.Value="Not Complete","Not Complete",DateDiff("d",Fields!ENTDTE.Value,Fields!COMPDATE.Value))

    What I want is for it to return Not complete if the value in Compdate = Not complete otherwise do the datediff however I get #Error when Compdate = not complete. What gives?

    DateDiff part works fine, confused why the other result is an error. Thanks

  • October 13, 2011 at 12:26 pm

    #1394286

    Isn't COMPDATE a date? How can it have a value of Not Complete?

  • October 13, 2011 at 12:31 pm

    #1394288

    It is a date, however, when the call is not complete date is 01/01/1900. We remove that date with a isnull command and set it to "Not Complete" for reporting purposes.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply