CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

There was a problem retrieving the XML data: Forbidden

edited Jun 24, 2014 10:51AM in CRM On Demand - Reports and Dashboards (MOSC) 2 commentsAnswered ✓

Hi,

I am running a report that calculates dates, one of them is compare 3 dates, and get the most recent one, called LastDate. THEN, I have to gets the difference of the LastDate from DeliveryDate and based on the number of dates, I will catagorize the number of differences 1 , 2, etc, NEXT, I have to explain 1. 30 days before due, 2. 29-15 before due etc..

the problem is I cannot just compare if TIMESTAMPDIFF(B,A) and TIMESTAMPDIFF(B,A) then A, etc. because when some of these dates are NULL the formula will not work. hence I have to check if there is NULL dates involved. and as I work deeper into the formula, I have to drag the main formula all the way when I have to explain the dates difference.

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center