This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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...