Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Case When for date fields — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Case When for date fields

Accepted answer
35
Views
2
Comments
edited Mar 21, 2018 3:52PM in General Transactional Reporting (OTBI) 2 comments

Summary

Case when date is lesser than or equal to another date, THEN "on time", ELSE, "Not on time"

Content

I'm trying to build a Case statement that shows If one date is lesser than or equal to another, say "on time", else, say "not on time" (or some other decided upon phrase). Is that possible to do in OBIEE? Or can I only do Case statements when the the "Then" and the "Else" are other columns? Any thoughts on how to trick the column to do what I want it to do?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!