I have a VB.net application that uses SQL server 2005. When I created new records in my application I save todays date in a date time field using Now(). When I try and slected records that were created today"m/d/yyyy" I can not get any records.
I am using SQLClient for my database connection.
This is my selection statment:
"Select * From Leads Where CONVERT(VARCHAR(20),CreatedDate, 101) = '" & DateTime.Parse(Now()).ToString("m/d/yyyy") & "'"
Any help would be appreciated.