Failed to execute query: SYNTAX_ERROR: line 12:30: '-' cannot be applied to date, integer (HRESULT: 80131500)

Hi,

when I try to edit the SQL of my Information link to get in the recent few days of data from my table, facing the below error message

Failed to execute query: SYNTAX_ERROR: line 12:30: '-' cannot be applied to date, integer (HRESULT: 80131500)

 

Where clause in my Information link is as below,

 t1."date" <= current_date - 4

(1) Answer

Login