Forum Discussion

RnVssR's avatar
RnVssR
Regular Visitor
2 years ago
Solved

Calculate tommorow value

Hi, Should i approach the following? In a IT tickiting dashboard, I want tasks scheduled for tomorrow to have a specific color. My idea was to achieve this using conditional formatting, where i crea...
Need Help
  • RnVssR's avatar
    RnVssR
    2 years ago

    Hi, thank you for your response. I think the reason it failes is because of the date/time format. In my colomn resulutiondate i got a date+time value. I found another formula using function DATEVALUE which is the solution:

    DATEVALUE(OperationsActivities[resolutionDate]) = TODAY() +1
Pfandgiraffe's avatar
Pfandgiraffe
Frequent Visitor
2 years ago

Hi RnVssR ,

 

works well for me.

Maybe your column do not use the right data type?

 

 

 

 

  • RnVssR's avatar
    RnVssR
    Regular Visitor
    2 years ago

    Hi, thank you for your response. I think the reason it failes is because of the date/time format. In my colomn resulutiondate i got a date+time value. I found another formula using function DATEVALUE which is the solution:

    DATEVALUE(OperationsActivities[resolutionDate]) = TODAY() +1