Forum Discussion
I see two issues.
The first is that the table name should not be in quotes [_DBID_TASKS].
Size(
GetRecords("{99.OAF.'"&[Date]&"'}AND{77.OBF.'"&[Date]&"'}", [_DBID_TASKS])
)
The second is that the end date fid 99 might be blank. I suggest that you make a new field in the Assignments table called [End Date or Today] with a formula of
IF(IsNull([End Date]), Today(), [End Date]) so that it will always have a date. The use that field's Field ID instead of 99 in your Formula Query.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Oh my goodness, the quotes were the problem! I actually started with a formula copied and pasted from the Formula queries Help page specifically so I didn't have to worry about getting all the punctuation right. It may need to be corrected:
Your other solution for the blank end date is excellent, that will be helpful for many other situations as well. Thank you much!
------------------------------
Amy Christensen
------------------------------