Forum Discussion

JeffPeterson1's avatar
JeffPeterson1
Qrew Captain
4 years ago

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

3 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    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
    ------------------------------
    • JeffPeterson1's avatar
      JeffPeterson1
      Qrew Captain
      4 years ago
      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
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        4 years ago
        Can 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
        ------------------------------