Formula Checkbox and Duration

Question

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

Best answer by MarkShnierYou

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

MarkShnierYou · Accepted Answer

Did you something like this?[My Duration Field] = Days(1)or[My Duration Field] = Days(0)------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Sign up

Login to the community