Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Time Comparisons with NOW()

Hello,  In a measure, I am trying to compare the time from NOW()to a static value using TIME(), but it is only working on the < condition. The function NOW() is returning 7/28/2020 11:18AM What...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

amitchandak This works with the first condition, but it is still returning Blank() when I try:

NOW() > Today() + Time(3,30,0)

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , hope you using that in a fi or filter 

 

try like

if(NOW() >( Today() + Time(3,30,0)) ,1,0) 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    amitchandak I am using it as a report page filter. I actually made a mistake in my post, as It is actually a calculated column in my date table rather than a measure. 

    Regardless, 

    if(NOW() >( Today() + Time(3,30,0)) ,1,0) works and returns 1. 

    Any idea on why it's returning blank when I switch the true condition to TRUE() and the false condition to FALSE()?

     
    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

      Anonymous , I did not get that 

      I tried 

      Measure =NOW() > Today() + Time(3,30,0) it retured true 
       
      I tried 
      Measure = if(NOW() > Today() + Time(3,30,0) ,True(),false())
      it retured true