Forum Discussion

Qrew Captain

5 years ago

Problem using DateTime field in formula for color coding

I'm trying to make a formula to control the colors on a report but I'm having trouble getting it to work. Here is my code: If([Due Date]>1+Today() "Reviewed", "Orange", [Due Date]>2+Today(), "Ye...

Qrew Cadet

5 years ago

try this:

If([Due Date]>Today()+Days(1), "Reviewed", "Orange", [Due Date]>Today()+Days(2), "Yellow", [Due Date]<Now(), "#ffcccb")

------------------------------
Amber Polston
------------------------------

JeffPeterson1
Qrew Captain
5 years ago
I'm getting an error: The operator '>' can't be applied on types datetime date

------------------------------
Jeff Peterson
------------------------------
- MarkShnier__You
  Qrew Legend
  5 years ago
  can you say bin worrds what the fomrula is suposed to do. The begining part here does not make sense.
  
  If([Due Date]>1+Today() "Reviewed", "Orange" ........
  
  ------------------------------
  Mark Shnier (YQC)
  Quick Base Solution Provider
  Your Quick Base Coach
  http://QuickBaseCoach.com
  mark.shnier@gmail.com
  ------------------------------
  - JeffPeterson1
    Qrew Captain
    5 years ago
    Yes, I just realized that the 'reviewed' doesn't belong here. This is meant to color rows on a report based on a field called [Due Date].
    
    If([Due Date]>1+Today() "Orange", [Due Date]>2+Today(), "Yellow", [Due Date]<Now(), "#ffcccb")
    
    ------------------------------
    Jeff Peterson
    ------------------------------