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)

Tahreem24's avatar
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")