Right sorting by date AND time

[haerti]

I have the following problem. I want to create a 3D-Graph that displays the time for a special transaction.

The table looks like this:

Datetime TransactionTime
13.05.2002 11:00:00 7.97
13.05.2002 13:00:00 6.56
13.05.2002 14:00:00 7.24
14.05.2002 12:00:00 8.65

One Axis should display the date, the other one the time and the third one the transactionTime. For this I use the formulas DateTimeToDate and DateTimeToTime.
When I use the options "on change of @DateTimeToDate" and "on change of @DateTimeToTime" it sorts first by the date and then by time. The sort order of the time is then 11:00, 13:00, 14:00, 12:00. But I want the 12:00 at the right place (between 11:00 and 13:00). Any ideas for that?

Thank you in advance!

 

[synapsevampire]

It sounds like you want it sorted by time and then date, and you have the reverse.

Then it would show

13.05.2002 11:00:00 7.97
14.05.2002 12:00:00 8.65
13.05.2002 13:00:00 6.56
13.05.2002 14:00:00 7.24

with the dates being the subsort.

This is all very speculative, not much to go on.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[haerti]

That's right, synapsevampire. When I first sort by time and then by date I get the right sorting by time but then not by date. it does not help me much in my 3D-Graph when the dates or the time are sorted like goodwill. Either I get a sorting order like 11:00, 13:00, 14:00, 12:00 or like 13.05., 14.05., 15.05, 12.05., on one of the graphs. I want one axis that sorts the time like 11:00, 12:00, 13:00, 14:00 AND the other axis like 12.05., 13.05., 14.05., 15.05..

Please help. Thank you.