>sometimes it is even worse - when u overlook the
>obvious
>and than "discover" it after staring at a problem
>for a long long time

Yup. At least here (my daytime job), I am one of the few who understands this stuff, so no one around here can say anything when that happens (g).

>
>>If I can't sort by dates, what good
>>is a data type, right?
>
>but this is exactly what DTOS [or DTOC(date,1)] is
>for
>and it accepts datetime expressions as well
>
>Arnon

But if I put that in, it will sort according to alphabetical order, not date order right? That is why I had the DBA put it in the yyyy/mm/dd format, as it would sort alphabetically as if it were sorting by date.

Scot.