SELECT() using todays date not working

[TedM]

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.

Phone No.s[Date]

[Chris_Jeal]

Hi,

I'm not sure of your data structure but maybe use a valid_if expression within the Number field of your Visitors table?

not(in([_THISROW].[Number],
select(
Phone No.s[Number],
date([Date])=today()
)
))

Chris

[TedM]

That's what I am doing actually....
But the expression just isn't working 😫

[scott192]

NOT(IN([_THIS],SELECT(Phone No.s[Number],TEXT(TODAY(),"DDMMYYYY") = TEXT([Date],"DDMMYYYY"))))

Put that into your Valid_If for your [Number] Field on your Form.

[TedM]

Thanks @scott192 - didn't need it in the end but your suggestion would have put me on the right track as did @Chris_Jeal 

👍

[TedM · Accepted solution]

Self fixed (which is probably the best way!)