Forum Discussion

SheilaAllas's avatar
SheilaAllas
Qrew Trainee
4 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
------------------------------
  • Did you something like this?

    [My Duration Field] = Days(1)
    or
    [My Duration Field] = Days(0)

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------

2 Replies

  • Did you something like this?

    [My Duration Field] = Days(1)
    or
    [My Duration Field] = Days(0)

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • SheilaAllas's avatar
      SheilaAllas
      Qrew Trainee
      That works!!  Thanks,!!

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