Unable to hide the text box

• sqldevlearn

  Old Hand

  Points: 397

  More actions

  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 3 years, 4 months ago by sqldevlearn.

• irgp

  SSC Journeyman

  Points: 80

  More actions

  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