jtaylor, Try using the .ToShortDateString() method provided via the DateTime object. For example, if you want to add by value, use DateTime.Now.ToShortDateString() and see if the current time is inserted as you expected. If so and you need to insert other date values, you'll need to establish new DateTime objects and set everything accordingly before inserting the .ToShortDateString() value.
I am not currently at a machine to test this, so please let us know if you find it successful (or if you don't!) Alan http://www.twitter.com/anachronistic
