datetime datacolumn

Maurizio

Guest

Posts: n/a

25th Aug 2003

I want to filter a datetime datacolumn; my expression
looks like this:
dim vDateTime as datetime
....
myDatatable.SELECT("ORDER_DATE <= #" & vDateTime.ToString
("u") & "#")

if order_date is a little bit smaller than vDateTime
(only a few hours) the records are not returnet!
What is wrong?
Thanx

« create runtime(on fly ) | White Space Problem »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can time zone be ignored in a DateTime DataColumn deserialization?	Joe	Microsoft C# .NET	2	6th Mar 2010 06:11 AM
datacolumn datetime from UTC to Localtime	georgejetson	Microsoft ADO .NET	2	7th Mar 2008 10:03 AM
DataColumn.Expression with DateTime Datatype	Matt F	Microsoft VB .NET	11	15th Mar 2007 05:19 PM
DateTime of Now in a DataColumn expression	Jon Fairchild	Microsoft ADO .NET	6	23rd Apr 2004 09:05 PM
DataColumn Expressions and DateTime	William Ryan	Microsoft ADO .NET	0	7th Aug 2003 10:00 PM