I have a select that works in one app but not in another, same table structure, etc…
SELECT(TimeCards[ID],
AND([Installer]=[_THISROW].[Employee],
[Task Date]>=[_THISROW].[Start Date],
([Task Date]<=[_THISROW].[End Date])))
The editor gives it a green light, but doesn’t send anything back
Try each of the AND conditions individually and confirm that they return the expected results.
Okay…hang on
The “name” field can’t be a ref. Thanks Marc!
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |