convert text feild in access to date feild

[rjkealey]

HEY ALL
I AM TRYING TO CONVERT A TEXT FEILD IN ACCESS WHICH HOLDS A DATE SUCH AS 12/21/05 TO A DATE FEILD ON MY ASP PAGE SO I CAN TRACK ORDERS PER MONTH SUCH AS SHOW ALL RECORDS WHICH HAVE 12/21/05

ANY HELP IS GREATLY APPRECIATED
RJKEALEY

 

[DotNetGnat]

Try this:

CONVERT(VARCHAR(10), YourDateField,101)

-DNG