GOOGLE SHEET FORMULA - QUERY STUFF FOR TODAYS DATE ONLY

Question

new poster here :-) this place as helped me throughout my years of learning I.T stuff as I progress through Adulthood

So this formula im having an issue with with is for a Google SHeet.

basically I want a SHEET that only displays todays ATTENDANCE, and not YESTERDAY or previous dates attendance. So I have two sheets (Today) and (NewData)

New Data (Sheet) Picture Reference

TODAY Attendance Sheet Picture 2 Reference

now my formula is this as follows, the part that is broken is the ending (everything after =, as the = should reference cell B1 of Today Attendance Sheet, so it auto populates any new inputted data throughout the day

=QUERY(NewData!$A$1:$H$136,"select A, C, B where E = date '"&TEXT(DATEVALUE("1/1/2000"),"yyyy-mm-dd")&"'",1)

BROKEN WRONG CODE is “”””= date '"&TEXT(DATEVALUE("1/1/2000"),"yyyy-mm-dd")&"'",1)“”””

Is date a named range on your sheet. It might be better to offer links to copies of your actual spreadsheet, with names removed or replaced. — Gabriel Pierce, Jun 24 '22 at 18:58
If my answer is sufficient please select it as being correct — Gabriel Pierce, Jun 26 '22 at 21:54
Related: https://stackoverflow.com/questions/45782256/how-to-compare-dates-with-query-on-google-sheets — TheMaster, Oct 05 '22 at 22:38

score 1 · Accepted Answer · answered Jun 24 '22 at 19:16

1

I like FILTER better than QUERY

=FILTER({'New Data'!A2:A,'New Data'!C2:C,'New Data'!B2:B}, DATEVALUE(LEFT('New Data'!A2:A,FIND(" ",'New Data'!A2:A))) = $B$1)

Todays Attendance Sheet

New Data Sheet

answered Jun 24 '22 at 19:16

Gabriel Pierce

396
3
11

1

thank you!! and yes that filter function is much more practical and what I needed to get this done :) thanks. – IT VICEROY Jun 27 '22 at 12:53

GOOGLE SHEET FORMULA - QUERY STUFF FOR TODAYS DATE ONLY

1 Answers1

Todays Attendance Sheet

New Data Sheet