convert SQL date into dd/mm/yyyy 1

[colinbell]

Hi I have a SQL table where the dates are stored in US format yyyy-mm-dd 00:00:00:000
I have an asp page where the user can enter date parameters as dd/mm/yy
this isn't returning the records I'd like - is there a function I can use to convert what the user enters to match records in the SQL table ?

regards
ian

 

[snowboardr]

just use Now in your sql, its a sql function

www.sitesd.com
ASP WEB DEVELOPMENT