Jan K. van Dalen
|
| Posted: 11/05/2007, 8:32 AM |
|
Hi Everyone,
I have a table with a datetime field which containts both date & time info.
I want to filter a grid (ASP but I don't think it matters) and my selection
Where clause has this entry (as an expression):
convert(char(10),Calendar.StartDateTime,101) = '{s_date}'
s_date is an URL parameter and is formated as: mm/dd/yyyy
I'm not getting any records
I tried using Paremeter and I only get those records with no time info
(IOW, 12:00:00 AM) ... hence why I was trying to use the convert() function.
Any ideas?
|
|
|
 |
|
