foxpro dbf vb datetimepicker custom format

how to query this one with semicolons and ""
because it's so hard it's on VB
I keep on mssing the ""
The format of the datetime in DBF is
date is 8/1/2013

So how to query
OleDBSelectCommand.CommandText = "select a from clkdata where Time >= ????(DATETIMEPICKER WITH THE FORMAT OF the date on the DBF)" Thanks ;)
Who is Participating?
Olaf DoschkeConnect With a Mentor Software DeveloperCommented:
Date and Datetime are a binary field type, what you see in BROWSING a DBF is always a conversion to a human readable format. On the one side that doesn't matter, on the other side as in MSSQL conversion of strings to binary dates or datetimes is done with current settings for date format. But there are setting independant ways to specify a datetime,

For example if you have year,month,day, hour, minute, second simply put it into the commandtext as TIME>=DATETIME(2012,12,31,23,59,59)

Or as  TIME>={^2012-12-31 23:59:59}

.NET gives you tons of ways to format a datetime type to a string as you need it, eg using the TryParseExact method, see

Bye, Olaf.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.