CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

Converting Dates into Character?

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

We are trying to get a Date field into Month / Year format in a report.  In order to get the reporting column into Month / Year format, we are converting the column into a String.  The String works, but when you try to sort on the column the report is treating the Month / Year as text (ex. the order appears as 1, 10, 11, 12, 2, 3, etc.).  Any idea on how to enable the sort to work correctly?  Below is the formula we are using.

CAST(YEAR(Indexed Date) AS CHAR) || ' / ' || CAST(MONTH(Indexed Date) AS CHAR)

Thanks!

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