GSheet: Query rows within date range in different columns

Question

I have a spread sheet with a list of names for which there are a specified date ranges. What I'm trying to achieve is to get the name of the person whose date range falls within the current week.

So far I've come up with this query but it does not return the correct name. What it actually does is just return the first 2 names without any regard to the where clause conditions.

=QUERY(A2:C;"SELECT A WHERE B >= "&TODAY()&" AND C <= "&TODAY()+6&" LIMIT 0";2)

I can't figure out what could be the problem here.

player0 · Accepted Answer · 2022-05-31 13:07:33Z

1

try:

=QUERY(A2:C; 
 "select A 
  where B >= date '"&TEXT(TODAY();   "e-m-d")&"' 
    and C <= date '"&TEXT(TODAY()+6; "e-m-d")&"'"; 0)

answered May 31, 2022 at 13:07

player0

131k14 gold badges91 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

GSheet: Query rows within date range in different columns

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related