Forum Discussion
MarkShnier__You
Qrew Legend
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
------------------------------
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
------------------------------
JeffPeterson1
4 years agoQrew Captain
It keeps throwing the same error for the '>' symbol: The operator '>' can't be applied on types datetime, date
However, I changed the Now() to Today and it seems to be working now.
------------------------------
Jeff Peterson
------------------------------
However, I changed the Now() to Today and it seems to be working now.
------------------------------
Jeff Peterson
------------------------------
- MarkShnier__You4 years agoQrew LegendWhat field type is your due date field?
Can you post the formula you are using?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- JeffPeterson14 years agoQrew CaptainIt's a Datetime type field.
Here's the current formula:
If(
ToDate([Due Date]) > Today()+Days(1), "Orange",
ToDate([Due Date]) > Today()+Days(2), "Yellow",
ToDate([Due Date]) < Today(), "#ffcccb")
------------------------------
Jeff Peterson
------------------------------- MarkShnier__You4 years agoQrew LegendCan you post the error message you get when you try to save the formula? Does the formula save OK, if so nevermind the yellow warning icon.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------