Query Question - search after date
I am trying to count how many records there are that are tied to the same customer and that come after the current record by date using the formula: Size(GetRecords("({6.EX."&[CustomerID]&"}AND{8.AF....
Forum Discussion
It is maybe happening because of parenthesis you have for query.
Try this:
Size(GetRecords("{6.EX."&[CustomerID]&"}AND{8.AF."&[Activity Date]&"}",[_DBID_ACTIVITIES]))
------------------------------
Razi D.
Desta Tech LLC
razi@destatechs.com
------------------------------
Try this:
Size(GetRecords("{6.EX."&[CustomerID]&"}AND{8.AF."&[Activity Date]&"}",[_DBID_ACTIVITIES]))
------------------------------
Razi D.
Desta Tech LLC
razi@destatechs.com
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendRazi,
Good catch.
That's why I always write them as
var text QUERY = "{6.EX."&[CustomerID]&"}AND{8.AF."&[Activity Date]&"}";
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Good catch.
That's why I always write them as
var text QUERY = "{6.EX."&[CustomerID]&"}AND{8.AF."&[Activity Date]&"}";
Size(GetRecords($QUERY, [_DBID_ACTIVITIES]))
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- That is much easier to read - I think I'll start using the local variables like that, even if it is a simple query.
------------------------------
Edward Hefter
www.Sutubra.com
------------------------------
