Using Dates in a CASE calculation

[GoHogs]

I can't seem to get this to work. A good example is having a conference affiliation automatically assigned to a University based on the date a game is played. Here is a sample of what I have for two schools.

Case (

Team = “Univ. of Arkansas” and Date > 8/1/1992; “Southeastern Conference”;

Team = “Univ. of Arkansas”; “Southwest Conference”;

Team = “Florida International” and Date > 8/1/2005; “Sun Belt Conference”;

“Not Division 1A”)

Team and Date are the field names. However, the date part of the function doesn't seem to work. Any ideas?

[comment]

It won't work, because 8/1/1992 is not a date. It's "8 divided by 1, divided by 1992".

Best to use the Date() function to specify a date in a formula. Putting your data in fields, instead of hard-coding them into field definitions, is even better.

[mr_vodka]

I would recommend that instead of the case statement, you move towards a relational model such as this.

college_sports.zip

[GoHogs]

I never stepped into the world of relationships and tables before! I guess its a good time to learn.

Thanks