Current Week in a query
What is the correct syntax for the current week in this query? I have looked but cannot find it var text THISWEEK ="{8.EX.'CURRENT WEEK'} AND {17.EX.'6'} AND {7.EX.'Regular Hours'}; -----------...
Forum Discussion
Mark I tried that originally and the error message came back as
Please check the syntax of your formula. Look for mismatched parenthesis.... and the . after "IR" is highlighted in red
------------------------------
Hans Hamm
------------------------------
Please post (copy paste) your formula that fails the formula editor.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- var text THISWEEK ="{8.IR.'this wk'} AND {17.EX.'6'} AND {7.EX.'Regular Hours'};
GetRecords($THISWEEK),9)
------------------------------
Hans Hamm
------------------------------- It would also help to see the error message but you are missing a closing quote
var text THISWEEK ="{8.IR.'this wk'} AND {17.EX.'6'} AND {7.EX.'Regular Hours'}";
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- Mark that fixed that issue, but now when I try to sum the values. It tells me that it is expecting a number. Field 9 is numeric and the field type I am using here is numeric.
var text THISWEEK ="{8.IR.'this wk'} AND {17.EX.'6'} AND {7.EX.'Regular Hours'}";
SumValues(GetRecords($THISWEEK),9)
------------------------------
Hans Hamm
------------------------------
