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")
Support 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: "(" ...
Support 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")&"' ")