CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

Dashboard Filter

edited Nov 21, 2012 10:42AM in CRM On Demand - Reports and Dashboards (MOSC) 2 commentsAnswered ✓
We are trying to create a dashboard filter that uses a date.  The operator being used for the date filter is "Is Between".  The default for the date should be the first day of the previous year and the first day of this month for the previous year.  For example, today is 11/20/2012 so the date filter would default to 1/1/2011 and 11/1/2011.  Any ideas on how to do this??? 

I suspect two SQL statements will work, but I'm not sure how to write the statements.  Below is a statement that I tried modifying, but it gives the first day of the month for this year (11/1/2012), I need it to be 11/1/2011.  I also need another statement to give 1/1/2011.  Any ideas are appreciated. 

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