I've also tried a variation on a query posted by MarkShnier , but I'm not able to get a distinct count - it's only returning zeros:
var text QUERY =
"{145.EX.'" & ("{145.OBF.'" &[Date of Interaction]) & "'}";
Size(
GetRecords($QUERY))
Qrew LegendOK, try this.
var text QUERY =
"{145.EX.'" & [my email field] & "'}"
& " AND "
& "{145.OBF.'" &[Date of Interaction]) & "'}";
Size(
GetFieldValues(
GetRecords($QUERY),3))
Note that in Formula Queries there is not a COUNT function. It's called Size. ie Size means to count the number of records returned by the Query.
