How to Stop a VARCHAR Type Date Column From Ordering Alphabetically?
(Doc ID 2003755.1)
Last updated on NOVEMBER 23, 2019
Applies to:Business Intelligence Server Enterprise Edition - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
Have a VARCHAR type column for Dates which contain dates in the format MMM-YYYY (for example APR-2015). When using this column (example: Month_Desc) in answers or in prompts, the data is sorted alphabetically.
How can it be sorted by date sequence (not alphabetically)?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document