Using date functions in where clause

Hi all,

We are running AES 7.9.

I submitted this query: SELECT adddate(curdate(), INTERVAL 1 DAY) FROM some-index* which is simpler than the query I need which is the use of dates and date functions in the where clause.

And received this error (note: adddate will work when applied to timestamp but not this embedded function call. I don’t see anything wrong any suggestions or recommendations)

: Bad Request, this query is not runnable.

“error”: {
“reason”: “Invalid SQL query”,
“details”: “”,
“type”: “NullPointerException”
“status”: 400