Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
I would use Today(2) -- date document was opened -- as more efficient. So either:
=Floor(ReloadTime()) <> Today(2)
or
=NOT InDay(ReloadTime(), Today(2), 0)
-Rob
No luck with one I have found One that it works if i go to font> calculated then use the expression however with the text box that displays a warning icon i have no luck
No luck with one I have found One that it works if i go to font> calculated then use the expression however with the text box that displays a warning icon i have no luck
For the warning Icon I went with =IF(Floor(ReloadTime()) < Today(2), 'qmem://<bundled>/BuiltIn/cross_r.png', '')
For the warning icon i used =IF(Floor(ReloadTime()) < Today(2), 'qmem://<bundled>/BuiltIn/cross_r.png', '') and it works
Hi Bruce,
What is the frequency of your load ? If it is daily then daily "DD/MM/YYYY' would be enough. If the frequency of the load is more than twice in a day then you will require time stamp to compare both reload time and today().
Regards
KC
Hi Bruce,
Pfa sample. Hope this is you are looking for.
Regards
KC
Hi,
Instead of converting to Date, convert it to num (used floor and it contains decimal values) and do the comparison it will work as expected,
=IF(Floor(ReloadTime()) = Floor(Today()), 0, 1)
Regards,
Leni
Hii
Try this one. It works 100%
=IF(
Floor( num(DATE(ReloadTime(),'DD/MM/YYYY') ) )
=
Floor( num( DATE(Today(),'DD/MM/YYYY')))
,0,1)
Put both conditions in variables if possible and use variable here in comparison.
Thanks in advance.
Regards,
Lalit
It might be help
=if(Floor(ReloadTime())=Floor(Today()),0,1)