Trying to find a formula that calculates 24 hours before now

Question

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.&nbsp;------------------------------Dawn Rene------------------------------

markshnier__you · Answer

Try this

IF(
now() - [registration_completion] &lt;= hours(24), "yellow")------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

dawnrene3 · Answer

Brilliant! Thank you very much!------------------------------Dawn Rene------------------------------

Forum Discussion

Trying to find a formula that calculates 24 hours before now