We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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!