Select() isnt working, but does in another app

[Rod]

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

[Marc_Dillon]

Try each of the AND conditions individually and confirm that they return the expected results.

[Rod]

Okay…hang on

[Rod]

The “name” field can’t be a ref. Thanks Marc!