-
Jul 28th, 2005, 08:43 AM
#1
Thread Starter
Fanatic Member
[RESOLVED] Date Time Picker - Remove Time
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|