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