Discussions

Expand all | Collapse all

Coding Help for a range of dates

  • 1.  Coding Help for a range of dates

    Posted 28 days ago
      |   view attached

    Hello,
    I am really struggling trying to figure out how to create a formula. I have done so much research on and it is already an area I struggle in.

    I am trying to create a formula that will highlight the rows in a report a color depending on how overdue they are.

    e.g. less than 30 days is no background color
    30-59 days overdue would be yellow
    60-89 days overdue would be green
    90 days and over would be red.

    Can you please help me with this?

    Thank you!!



    ------------------------------
    Jennifer Doescher
    ------------------------------


  • 2.  RE: Coding Help for a range of dates

    Posted 28 days ago

    What is your current formula?



    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quick Base Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------



  • 3.  RE: Coding Help for a range of dates

    Posted 28 days ago

    Your color code formula should look something like this:

    If([Days Past Due]<30,null,

     If([Day Past Due]>=30 or [Day Past Due]<60, "Yellow",

     If([Day Past Due]>=60 or [Day Past Due]<90, "Green","Red")))

     



    ------------------------------
    GMacri
    ------------------------------