How are you inserting the data? with a SqlCeCommand and Parameter for the
date value? in that case you can parse the date into a DateTime value and
set that as your parameter value. Take a look at the DateTime.Parse method
for how to specify a particular format.