New doc: EOWEEK()

[Steve]

For the recently-added function:

help.appsheet.com

EOWEEK()

Date of last day of a week from Date or DateTime

[MultiTech]

Noice

[MMangen]

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

[SkrOYC]

---

@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