Valid if condition

[Rik_Rowe1]

I'm trying to create a Valid If condition on a (text) field in Table A based on using a (date) field from Table B. The condition evaluates as true and it should not for every row in the small table B.  My Valid If Is:

SELECT( Weeks[WeekRange], ANY(Weeks[WeekEnd]) < DATE('11/01/2024'))

Thoughts? 

[Aurelien · Accepted solution]

Hi @Rik_Rowe1 

Can you try this:

SELECT(Weeks[WeekRange]
  [WeekEnd]<ANY(tableB[date])
)

[Rik_Rowe1]

Off course your suggestion worked! I appreciate you helping me get more sleep!!