Calculate tommorow value

[RnVssR]

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 create a new colomn next to the resolutionDate to calculate tomorrow, so i can use that as condition. I wanted to use the Today() +1 function, but somehow the calculation for today is nog right
For an example see below, where I dit not put the '+1' in t, just to check if the calculation for 'today' is right. I should get '1' as output but I only see zero's.

What am I doing wrong? Or is there a better way to achieve my goal?

[Pfandgiraffe]

Hi @RnVssR ,

works well for me.

Maybe your column do not use the right data type?

[RnVssR · Accepted solution]

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