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")
Hi Wellness,
Your query looks good to me.
Are you getting any error when executing the connection?
Hi, yes I am getting the following error:
Google Sheets: Invalid query: PARSE_ERROR: Encountered " "toDate" "toDate "" at line 3, column 1. Was expecting: "(" ...
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")&"' ")
A free forum powered by FreeFlarum (remove this footer)Terms & Conditions | Privacy Policy