Conditional Show

[#1]

Dear All,

I have a text box that I want to show based on a condition but it is not working. Am i missing something???

IF(DATE(ReloadTime(), 'DD/MM/YYYY') = DATE(Today(), 'DD/MM/YYYY'), 0, 1)

[sunny_talwar]

Try this as your conditional hide/show expression:

=Floor(ReloadTime()) = Floor(Today(1))

[#3]

No luck there Still not working

[sunny_talwar]

Have you checked in a text box object the value of the two things

=ReloadTime()

=Today()

are they both showing today's date or not?

[Anonymous]

Try this

= DATE(ReloadTime(), 'DD/MM/YYYY') = DATE(Today(), 'DD/MM/YYYY')

[MK9885]

Refreshtime:

load

QvdCreateTime('$(vQVD_E_Directory)\YOURFACTTABLE.QVD') AS QVDTIME

AutoGenerate 1;

You can use above script to generate a field for your QVD refresh time. If that's what your goal is?

Then use this field in front end.

[Anonymous]

Layout / Show / Conditional not need to use the "If".

Just the condition to be shown.

[#8]

The goal is to show text in a text box informing the user that the reload failed hence the conditional show. if the reload is successful nothing will be shown the text box will be hidden. the text box has red font on the dashboard which says, " Reload failed please contact XXXX"

[#9]

Hi yes the dates are showing fine however The goal is to show text in a text box informing the user that the reload failed hence the conditional show. if the reload is successful nothing will be shown the text box will be hidden. the text box has red font on the dashboard which says, " Reload failed please contact XXXX"

The textbox will be hidden if Reloadtime() = Today()

The Textbox will show if reload time() is less than today. e.g. yesterday.

[sunny_talwar]

If they are the same and they need to be hidden, then you need this condition

=Floor(ReloadTime()) <> Floor(Today(1))