Luc Pattyn wrote: I don't understand why you would do inserts and selects differently Yes, I made things much too difficult. There's no need for splitting strings and all that. When I get a DataType back from the database and need to display it in text, I just go String^ text = ((DateTime)datarow[4]).ToString("dd MMM yyyy") And to put a text like the above into a query, I convert it back with String^ query = "SELECT * FROM myTable WHERE myDate = #" + text + "#)"; Things become embarrasingly clear once you get to see the whole picture :-O Luc Pattyn wrote: I have strong doubts your 2-digit dates did work correctly all the time That sounds plausible. Thanks Luc modified on Thursday, August 26, 2010 11:05 PM