Forum Discussion

DawnRene3's avatar
DawnRene3
Qrew Trainee
2 years ago

Trying to find a formula that calculates 24 hours before now

I'm trying to find a formula to color a record row in a report that if the date in my date/time field, registration_completion, is within the last 24 hours, color it yellow.

This doesn't work so I know I'm missing something.

If(ToHours([registration_completion]=Hours(-24), "#00FF00")

Any ideas appreciated. Thanks. 



------------------------------
Dawn Rene
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    2 years ago

    Try this

    IF(

    now() - [registration_completion] <= hours(24), "yellow")



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • DawnRene3's avatar
      DawnRene3
      Qrew Trainee
      2 years ago

      Brilliant! Thank you very much!



      ------------------------------
      Dawn Rene
      ------------------------------