check a box after 24 hrs
I have a box that I would like to have checked 24 hours after my date field "Sent to Sales" is filled. Can anyone help with this formula? Thank you, Brandy ------------------------------ Br...
Forum Discussion
I want to use the check box as part of a formula for color coding.
------------------------------
Brandy Nunes
------------------------------
------------------------------
Brandy Nunes
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendBy 24 hours do you really mean the next day after the [Sent to Sales]
if so, then it will just be
IF(Today() > [Sent to Sales], true)
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
if so, then it will just be
IF(Today() > [Sent to Sales], true)
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- I do have two boxes, one for 24 hours and one for 48.
is it possible to do something that says the following for one box:
IF(Today()-1Day = [Sent to Sales], true)
and the following for the 48 hrs
IF(Today()-2Day = [Sent to Sales], true)
------------------------------
Brandy Nunes
------------------------------ - I also tried the formula you provided and I get an error that says:
"The operator '<' can't be applied on types datetime, date
Does this mean I need to change my field type to just date?
Thank you,
Brandy
------------------------------
Brandy Nunes
------------------------------- For that comparison yes it needs to be just a date field.
You could go by just date but then this may not do exactly 24 hours. Say a person entered a record at night today and then went to the report tomorrow, if you just go by the date and not the time then that record would be checked the next day even if it was only about 12 hours away. If that is okay then this would work.
Either way this is the way I would personally attack this. This ensures it is 24 hours after the fact and no sooner. This assumes [Sent to Sales] is Date/Time.
if(
Now() - [Sent to Sales] > Hours(24), true
)- Awesome!! Thank you
------------------------------
Brandy Nunes
------------------------------
