CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

merge two columns

edited May 31, 2012 1:04AM in CRM On Demand - Reports and Dashboards (MOSC) 1 commentAnswered
qq I have two different date columns in oracle I want to be able to merge them to get a date prompt that will cover the two different date

CASE Opportunity."Close Date" WHEN  Opportunity.DATE_28 END

 

CASE Opportunity."Close Date  this is  the opportunity expected  close date

 

Opportunity.DATE_28   this is the actual close date

 

I need to look at opts by both  expected close date and actual close date

And need to create a prompt to do this that will have both dates in the prompt

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center