Formula to check box based on duration result

Question

I am trying to create a checkbox formula field [Time to Appt <=7 days] that would check the box IF the duration field[Time to Appt] is <=7 days.

I have tried multiple formula variations and keep getting a syntax error message. Specifically the operator <= cant be used with durations. I've tried to convert the duration to a number or text, but still can't get it to work.

example:
If([Time to Appt. (days)]<=7 days, true,false)

I would like to be able to use a dynamic filter for records that have a duration of 7 days or less.
That is why I am creating a checkbox since dynamic filters cannot be duration fields.

Suggestions?

quickbasecoachd · Answer

try thisIf([Time to&nbsp;Appt. (days)] &lt;= Days(7), true,false)

shereebrown · Answer

Thank you!! It works.&nbsp; I hate to admit how much time I spent trying to figure this out.&nbsp; I don't have any training in this, just trying to teach myself.&nbsp; As always, I appreciate you help.

quickbasecoachd · Answer

no problem.A good link to bookmark is here&nbsp;https://login.quickbase.com/db/6ewwzuuj?a=td&nbsp; It gives all the functions with examples and there are some Dynamic filters, for example for "Duration" that might have led you to solve the problem quicker.

Forum Discussion

Formula to check box based on duration result

Related Content

Create a formula duration over 5 years

Duration Formula

Formula Checkbox and Duration

Duration Fields with Pipelines

Delete Formula Button Error