CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

Help with Case if statement

edited Apr 24, 2014 12:18PM in CRM On Demand - Reports and Dashboards (MOSC) 2 commentsAnswered ✓

I have an if then else statement i used in another application that I am trying to replicate in CRM on Demand witht he Opportunity."Close Date" field.

Can anyone help me translate this? I put the Opportunity."Close Date" field where it woudl be if theis statement worked

if (Opportunity."Close Date" >= _first_of_month(current_date) and Opportunity."Close Date" <= _last_of_month(current_date)) then ('30 Day') else if (Opportunity."Close Date" >= _first_of_month(_add_months(current_date,1)) and Opportunity."Close Date" <= _last_of_month(_add_months(current_date,1))) then ('60 Day') else if (Opportunity."Close Date" >= _first_of_month(_add_months(current_date,2)) and Opportunity."Close Date" <= _last_of_month(_add_months(current_date,2))) then ('90 Day') else ('90+ Day')

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