Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Howto build a Select filter with DateTime
Message
From
24/09/2007 04:00:57
 
 
To
22/09/2007 19:40:09
John Baird
Coatesville, Pennsylvania, United States
General information
Forum:
ASP.NET
Category:
ADO.NET
Miscellaneous
Thread ID:
01256085
Message ID:
01256191
Views:
14
>>>
>>>DataRow[] rows = dt.Select("BackupType=1 AND BackupFinishDate < #" + ds + "#");
>>>
>>
>>Hi,
>>I think I tried this. Anyway, same problem I'm afraid. FWIW expression expands as:
>>"BackupType=1 AND BackupFinishDate < #22/09/2007 17:49:48#"
>
>
>Try using .ToShortDateString() instead of .ToString();

Hi,
Same error I'm afraid. Plus I need the time comparison....
Regards,
Viv
Previous
Reply
Map
View

Click here to load this message in the networking platform