Discussions

Expand all | Collapse all

check a box after 24 hrs

  • 1.  check a box after 24 hrs

    Posted 08-23-2021 09:58
    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

    ------------------------------
    Brandy Nunes
    ------------------------------


  • 2.  RE: check a box after 24 hrs

    Posted 08-23-2021 10:23
    Edited by Austin K 08-23-2021 10:23
    Does the checkbox need to trigger anything itself right when it becomes checked like an automation or can it just be checked on the record after 24 hours and then it triggers form rules or something else when a user next interacts with the record?


  • 3.  RE: check a box after 24 hrs

    Posted 08-23-2021 10:27
    I want to use the check box as part of a formula for color coding.

    ------------------------------
    Brandy Nunes
    ------------------------------



  • 4.  RE: check a box after 24 hrs

    Posted 08-23-2021 11:04
    By 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
    ------------------------------



  • 5.  RE: check a box after 24 hrs

    Posted 08-23-2021 11:41
    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
    ------------------------------



  • 6.  RE: check a box after 24 hrs

    Posted 08-23-2021 12:03
    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
    ------------------------------



  • 7.  RE: check a box after 24 hrs

    Posted 08-23-2021 14:21
    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
    )



  • 8.  RE: check a box after 24 hrs

    Posted 08-23-2021 16:41
    Awesome!! Thank you

    ------------------------------
    Brandy Nunes
    ------------------------------