order by format

[adnil]

i have to_char a date in my script and giving it a heading of Step14 completed date:
TO_CHAR("TL_EVENTS"."COMPLETED_DATE", 'DD/MM/YYYY') "Step14 completed date"

at the end of the script, i'm trying to order by this date:
ORDER BY
"Step14 completed date"

my question is: how can i get the script to order by the month, then the day, then the year in ascending order?

thank you.

 

[DietSquirt]

Can you order by TL_EVENTS.COMPLETED_DATE even though you're not going to show it as-is?

 

[adnil]

Hiya, when I try to order by TL_EVENTS.COMPLETED_DATE, I am getting an ORA-01791 error message: not a SELECTed expression

 

[xlbo]

nothing to do with SSRS - please post questions like this in the SQL Programming forum in future

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question