I have run the ISDATE function and all rows (30449) returned 1

Sorry, forgot to answer your question in my previous post . . .

the data type is set to nvarchar(10)

I have tried the convert function (to datetime) but then get an 'arithmetic overflow error converting expression to data type datetime'.

I have also amended the view to reference a different...