Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Order by date field
Migrateduser
I have a report which includes a date field (format is dd/mm/yy), I want these dates to appear in ascending order but when I include "order by (date field)" in the sql the dates appear in order of the dd value. E.g. 04/04/12, 07/07/12, 12/03/12.
I`ve also specified the order in the sorting for the table but it doesn`t seem to help.
This has got to be easy, help a newbie out please.
Find more posts tagged with
Comments
There are no comments yet