Forum Discussion

DawnRene3's avatar
DawnRene3
Qrew Trainee
11 months 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 ...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend

Try this

IF(

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



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

Brilliant! Thank you very much!



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