Hi

I have a date value that is being brought back from a database that I want to put into a datetimepicker on my form. Unfortunately some of the existing data is rather messy and some dates have only been put in as the year. This means that I get an error when trying to put something like 2003 into a datetime picker that is expecting a ddmmyyyy format.

Is there any way that I can either check if the data is in the ddmmyyyy format or could I convert it to that format for populating the datetimepicker?

Thanks.