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

------------------------------

Original Message:

Sent: 10-01-2020 15:54

From: Mark Shnier (YQC)

Subject: Problem using DateTime field in formula for color coding

What 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

Original Message:

Sent: 10-01-2020 15:23

From: Jeff Peterson

Subject: Problem using DateTime field in formula for color coding

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

Original Message:

Sent: 10-01-2020 14:33

From: Mark Shnier (YQC)

Subject: Problem using DateTime field in formula for color coding

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

Original Message:

Sent: 10-01-2020 14:09

From: Jeff Peterson

Subject: Problem using DateTime field in formula for color coding

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

Original Message:

Sent: 10-01-2020 13:45

From: Mark Shnier (YQC)

Subject: Problem using DateTime field in formula for color coding

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

Original Message:

Sent: 10-01-2020 13:42

From: Jeff Peterson

Subject: Problem using DateTime field in formula for color coding

I'm getting an error: The operator '>' can't be applied on types datetime date

------------------------------

Jeff Peterson

Original Message:

Sent: 10-01-2020 13:35

From: Amber Polston

Subject: Problem using DateTime field in formula for color coding

try this:

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

------------------------------

Amber Polston

Original Message:

Sent: 10-01-2020 13:33

From: Jeff Peterson

Subject: 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(), "Yellow", [Due Date]<Now(), "#ffcccb")

I'm getting errors that '>' cannot be used with Date or DateTime fields and I haven't had success using ToDate to convert it. Any ideas how I might get this to work?

------------------------------

Jeff Peterson

------------------------------