Post reply

IsDate Format Issue

  • May 10, 2010 at 9:11 am

    #220897

    I'm getting a #ERRROR on the following format, the data that has the error is "//".

    I would have assumed that the IsDate would have taken care of this. Below is the expression statement

    =iif(IsDate(Fields!My_DATE.Value),FORMAT(CDATE(Fields!My_DATE.Value),"MM/dd/yyyy"),"")

  • May 10, 2010 at 10:34 pm

    #1165329

    Hi,

    Please provide snapshots and elaborate your requirements/error if any.

    Raunak J

  • May 11, 2010 at 5:29 am

    #1165457

    I found a post that stated the iif statement in reporting services evaluates both true and false first then does the evaluation. I changed my method of displaying and used embedded code on the report and it works well.

    Thanks

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

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