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 299
1 ACCEPTED SOLUTION

Self fixed (which is probably the best way!)

TedM_0-1683710405178.png

 

View solution in original post

5 REPLIES 5