FILTER() Documentation Example

(Eric Schwartz) #1

filter() documentation shows the example:
FILTER([DateStart_wDay], [End] = “07:15:33”)

Using this syntax generates the error:
Function ‘FILTER’ should have exactly two parameters, a table name and a filter condition

Replacing [ table ] with “table” works. Is there a case where [table] is appropriate?

(Aleksi Alkio) #2

Where do you see it like FILTER([DateStart_wDay]…)?

(Eric Schwartz) #3

Hi Aleksi,
It appears in the code editor, LISTS functions page, as the example for FILTER().

(Aleksi Alkio) #4

okay, thanks.

(Steve Coile) #5

Nope. The first argument to FILTER() must be a quoted or unquoted literal table or slice name, and may not be an expression.

(Eric Schwartz) #6

Thanks again Steve.
Tagged as Bug-issues-errors

1 Like