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 | |
32 | |
30 | |
18 | |
16 |