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

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
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    5 years ago
    Ambers modified formula should work
    
    If([Due Date]>Today()+Days(1), "Orange", [Due Date]>Today()+Days(2), "Yellow", [Due Date]<Now(), "#ffcccb")
    
    If the [Due date] field is in fact a date/ time field type, then
    
    If(
    ToDate([Due Date]) > Today()+Days(1), "Orange",
    ToDate([Due Date]) > Today()+Days(2), "Yellow",
    ToDate([Due Date]) < Now(), "#ffcccb")
    
    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------