Announcements
The Google Cloud Community will be in read-only from July 16 - July 22 as we migrate to a new platform; refer to this community post for more details.

SELECT() using todays date not working

I have two tables - "Visitors" and "Phone No.s".

When someone creates a new entry in Visitors I want to check the number they are entering hasn't already been entered (in Phone No's) that day. 

I'm trying create the list to check against using:
LIST(SELECT(Phone No.s[Number],date(TODAY()) = DATE(Phone No.s[Date])))
but when I test it I'm not getting anything in the list.

TedM_0-1683625922149.png

Phone No.s[Date]

TedM_0-1683626765412.png

 

 

 

Solved Solved
0 5 350
1 ACCEPTED SOLUTION

Self fixed (which is probably the best way!)

TedM_0-1683710405178.png

 

View solution in original post

5 REPLIES 5
Top Labels in this Space