Need help to use the today() function

Wellness

I'm not familiar with Query syntax and need help to use the today() function, please. Its a daily workflow and I want to select data from 16/Dec up to 15 days from when the query is run.
Here's my query. Please help me to fix it.
SELECT A, B, C, D, E, F, H, I, K, M, N, R, AF, W WHERE
TODATE(A)>=DATE '2021-12-16' and
TODATE(A)<=DATE TEXT((TODAY()+15),"yyyy-mm-dd")

Bobby from Sheetgo

Hi Wellness,

Your query looks good to me.

Are you getting any error when executing the connection?

Wellness

Hi, yes I am getting the following error:

Google Sheets: Invalid query: PARSE_ERROR: Encountered " "toDate" "toDate "" at line 3, column 1. Was expecting: "(" ...

Bobby from Sheetgo

Please try the below one:

=query( A:AF ,"SELECT A, B, C, D, E, F, H, I, K, M, N, R, AF, W  WHERE
TODATE(A) >= DATE'2021-12-16' and
TODATE(A) <= DATE'"&TEXT((TODAY()+15),"yyyy-MM-dd")&"' ")