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

 

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

2 Replies

    • 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