In my research I have found that SQL doesn't really store the datetime values the way it looks in query anaylzer or enteprise manager.<BR><BR>Here's where I might be getting off the right track.

Thanks for the info all.<BR><BR>For my current need, a trimmed format did the trick but I'll keep in mind datepart and datename.