Hi Colby,
Your suggestion works for the most part, except that I am getting a DateTime field overflow now. I am guessing that this is because the field in question is a SmallDateTime instead of a DateTime. (We decided to go with this since we only need that particular information up to the minute, so we could save some space in the db)
With that being said, is there an easy way to cast the DateTime returned by ToDate() to a SmallDateTime?
If this was a new design I would simply change the relevant table fields to DateTime, but I am trying to replace an existing solution, so altering the database is less than ideal.
Thank you for the continued help.
–HandledException