The fact that we can run it as sa pointed us in the right direction - that this problem is caused by some customised active directory software we had installed....

Hi,

Problem solved! oddly enough if we run the udf using the sa account, it runs fine on all tables. Odd that we should get a data type error considering it...

They are all stored as datetime. That is why this error is so confusing. The entire development team here is confused by this. 🙂

I tried the isdate() function and all dates are fine. The function when used on the one table, fails, but is fine on another. Both table have their dates populated...

Hi,

Take a look at this article, it is a bit dated but does go through most of the reasons why you'd have this problem. It has helped me in the...

Hi,

Give this article a read -

http://dnjonline.com/article.aspx?ID=mar05_vbvscsharp

Jinx. 🙂