Post reply

Unable to hide the text box

  • March 23, 2022 at 9:44 am

    #4004693

    Hello all I am writing the following condition to hide the textbox based on a condition but some how it is not working

    I am able to set the value

    =IIF(FormatDateTime(Parameters!LiveDt.Value,2) < FormatDateTime(Parameters!visitdt.Value,2), "True", "False")
    =FormatDateTime(Parameters!LiveDt.Value,2) < FormatDateTime(Parameters!visitdt.Value,2)

    I am able to see the text correctly based on condition but unable to hide it

    • This topic was modified 2 years, 9 months ago by  sqldevlearn.

  • March 23, 2022 at 2:08 pm

    #4004813

    You are using two parameters (presumably they have a date data type) and converting them to strings using FormatDateTime: in other words you aren't comparing dates, you are comparing text. Remove the FormatDateTime and just compare Parameters!LiveDt.Value and Parameters!visitdt.Value

     

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

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