CharmaineSilver
5 years agoQrew Member
Formulas and checkboxes
Hi.
Just started on my first formula in QB and am having trouble with a check box.
Trying to say if half day is not checked add 1 day and if checked add 1.5 days.
Get the error message, expecting Boolean but found number on my second row of the formula.
The field is formula- numeric.
My first and last day fields are dates.
If([Half day],"No",
WeekdaySub([Last day of leave],[First day of leave])+1,
WeekdaySub([Last day of leave],[First day of leave])+1.5)
All help will be most appreciated
------------------------------
Charmaine Silverman
------------------------------
Just started on my first formula in QB and am having trouble with a check box.
Trying to say if half day is not checked add 1 day and if checked add 1.5 days.
Get the error message, expecting Boolean but found number on my second row of the formula.
The field is formula- numeric.
My first and last day fields are dates.
If([Half day],"No",
WeekdaySub([Last day of leave],[First day of leave])+1,
WeekdaySub([Last day of leave],[First day of leave])+1.5)
All help will be most appreciated
------------------------------
Charmaine Silverman
------------------------------