I have a bunch of datetime pickers on my form.

When I step through my program using F8 I notice that when the dtPicker is not changed by the user it writes a value to the database such as "07/25/2005".

The problem I'm having is that when the user changes the date on the dtPicker it shows up in the program as "07/25/2005 9:40:45AM" which is not working because my database field is not a datetime.

How can I trim the time off the end?

Is there a property that does this or do I have to resort to something like a MID or LEFT function to get the values I want?