Thanks so very much. It would look like MS would fix this.

I set my dates fields to "date" in sql and my time to "time(4)