>>and a follow-up....you're storing the date column as datetime, correct?
>
>How else can you store it?

Knowing me, it could be stored in a variety of way. :-)

At my last job, I was checking over the projects the individual I replaced did. The first thing I noticed was in one incredibly simple call logging application he decided to split date and time into two separate datetime fields.

And then I opened the VB.NET application, where the first thing the app did was open seven different connections to SQL Server and kept them open.

I knew then it was going to be an incredibly frustrating job. It was.