CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

different ways to filter for CURRENT_MONTH

edited May 28, 2014 12:00PM in CRM On Demand - Reports and Dashboards (MOSC) 1 commentAnswered

I have to build 2 reports:

1st report

Show all Service Requests Created in the current month.

I know I can use the CURRENT_MONTH session variable for a rolling filter without hardcoding the date range.

==> What is the syntax and how do I put it into a filter?

==> Can I use it on any date field (date/time?)

2nd report

3 columns each showing the following different numbers:

- Show all Service Requests Created in the current week.

- Show all Service Requests Created in the current month.

- Show all Service Requests Created in the current year..

For this I am using the same field 3 times and then in the Column Formula (fx) I need to use different formulae to calculate the different periods.

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