For the recently-added function:
Noice
I cannot get Google to recognize EOWEEK. my current formula pulls 3 months of data
=QUERY('CAL Defects'!A2:T,"Select * where I>= DATE '"&TEXT(EOMONTH(TODAY(),-3),"yyyy-mm-dd")&"' and I<=date '"&TEXT(now(),"yyyy-mm-dd")&"'")
I want to change it to pull 2 weeks
@MMangen wrote:EOWEEK
This is an AppSheet function, not GSheet one
Don't expect to use AppSheet functions out of AppSheet nor GSheet/MSExcel functions in AppSheet