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
------------------------------
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
------------------------------
