Forum Discussion

dinesh_kumar_g's avatar
dinesh_kumar_g
Frequent Visitor
4 years ago

Ticket Raised time and Initiated Time Dax

Hi All,   I have one requirement. I have ticket raised time and ticket initiated time columns. Ex: Ticket raised on time is 6:00 AM support team will Initiated that ticket time is 9:00 AM actual w...
General Comment
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

dinesh_kumar_g ,

if you are only worried about system time 

if(timevalue(now()) >= time(9,0,0) && timevalue(now())  < (18,0,0) ,"Yes", "No" )

 

you can add conditions

dinesh_kumar_g's avatar
dinesh_kumar_g
Frequent Visitor
4 years ago

Thanks for fast reply. I will try this.