Forum Discussion

SheilaAllas's avatar
SheilaAllas
Qrew Cadet
5 years ago
Solved

Formula Checkbox and Duration

I"m trying to complete a formula checkbox field that will tell me if my duration is 1 day or less on a record.

Duration is a formula duration field that calculates the date a task is completed - the date it was received and excludes weekdays.
ToWeekdayN(ToDate([Date Initial Review Complete]))-ToWeekdayN(ToDate([Date Created]))
The value display of the field is set to Days

I'm trying to use a formula checkbox field to determine if the record was completed in 1 day or less.  It will calculate correctly using 0 days but does not check if the record was done in 1 day.

Can anyone advise of the right formula to use?

Thanks,   


------------------------------
Sheila Allas
------------------------------

2 Replies

    • SheilaAllas's avatar
      SheilaAllas
      Qrew Cadet
      That works!!  Thanks,!!

      ------------------------------
      Sheila Allas
      ------------------------------