Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Using Dates in a CASE calculation

  •
GoHogs
in Calculation Engine (Define Fields)

Featured Replies

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?

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.

  • Author

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

Thanks

Create an account or sign in to comment
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Account

Navigation

Search

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.