SQL Server dates but text value

[Ggalla1779]

Hi

Am trying to filter on dates in a query in SQL Server...data has dates in text and my sql dont appear to be working

ie

SELECT [Date signed] FROM tblContactsCC WHERE ([Date signed] < CAST(N'01/10/2008' AS datetime))

SELECT [Date signed] FROM tblContactsCC WHERE [Date signed] <= convert(datetime, '01/10/2008',103)

What am I doing wrong.....