Forum Discussion

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...

Super User

6 years ago

Anonymous . because now is date and time. time is only time

Try like

NOW() < today()+ Time(3,30,0)

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

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)

Tahreem24
Super User
6 years ago
Anonymous ,

Try like a below:

Column1 = IF(NOW()>TODAY()+Time(3,30,0),"Yes","No")

Column2 = IF(NOW()<TODAY()+Time(3,30,0),"Yes","No")
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
  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
    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

Related content