Kleel- You're correct. That is indeed what I'm trying to do, but I can't figure out how to get CONVERT to change the data type of TheDate field from datetime to just a date.