I have a table named `Transaction` for customer transactions, it contains: 

```
CustomerID, 
Datetrans (transaction date)
Timetrans (transaction time)

```

I would like to return the max(Datetrans), given that a customer can make two transactions a day; I want to get the max value of Timetrans for that max Datetrans date. 

I have tried :

```
SELECT CustomerID, MAX(Datetrans), MAX(Timetrans) FROM Transaction

```

It returns the all time maximum time value from the whole table, not depending on the maximum date.
I have also tried some joins (outer and inner), alternating max(Datetrans) and max(Timetrans) and it didn't go through for some reason.
PLEASE HELP!