Post reply

error #VALUE after export to Excel

  • October 25, 2018 at 2:07 am

    #380334

    Hi,

    I'm creating RDLC report, and want to display some string value to be in date format. May I ask what's wrong with this expression ->

    =format(CDate(mid(Parameters!SearchConditionString.Value,12,10)),"MM/yyyy")
    As the named, "Parameters!SearchConditionString.Value" is a string value, which is the original text is "Basis date:25/10/2018" and I want to display it  to be Month Name and Year.

    The pain is right now when ever I export / display it in Excel, it show #VALUE error.

    Kindly help

    Thanks.
    Tony.

  • November 5, 2018 at 9:36 am

    #2012417

    You may have to break it down a little more such as:
    MonthName(CDate(mid(Parameters!SearchConditionString.Value,12,10))) & ", " & Year(CDate(mid(Parameters!SearchConditionString.Value,12,10)))

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

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