Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
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
edited Mar 21, 2018 3:52PM in General Transactional Reporting (OTBI) 2 comments


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


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.


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