Post reply

ssrs 2008 expression question

  • August 1, 2016 at 11:42 am

    #312150

    in an ssrs 2008 report, I have the following edit on a date field;

    = IIF(Fields!r1RedWalletSentDate.Value= 0 or Fields!r1RedWalletSentDate.Value=" " or IsNothing(Fields!r1RedWalletSentDate.Value), " ", Fields!r1RedWalletSentDate.Value)

    What I want to check for is if the value is 0, space, or is empty, display a space value. This works fine when there is a problem, but show #ERROR when the field contzins a real date.

    Thus would you show me how to fix the expression, so that it will work correctly?

  • August 1, 2016 at 11:56 am

    #1893021

    Try IsDate(Fields!r1RedWalletSentDate.Value)

    Sounds like you have data problems in your underlying tables. Why is there anything but dates in this column? Normally, date fields contain either a date value or NULL.

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

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