Skip to main content
Question

Trying to find a formula that calculates 24 hours before now

  • June 21, 2023
  • 0 replies
  • 57 views
Forum|alt.badge.img+5

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
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24

    Try this

    IF(

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



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
      Terms & ConditionsAccessibility statement