One of my virtuals stopped working. I haven’t touched it. Similar expressions are working fine accessing the same table, id’s, etc…
It’ comes back fine in the editor, when I test it zero results in return…am I missing something? Thanks!
Here it is
SELECT(TimeCards[TimeCardID],
AND(
([Installer Name]=[_THISROW].[Employee]),
([Task Date]>=[_THISROW].[Start Date]),
([Task Date]<=[_THISROW].[End Date])))
Where does it not work? In what way doesn’t it work?
It sends back nothing, blank
Before it was sending back all of the columns in the table, now…nothing.
working…
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |