DateTime problem with NT but not XP.....

[Steve]

I have a windows app running on several machines. Some are XP some are 2000
and a couple are NT SP 6. I have a search screen which can search on date.
When searching on date using the NT machine client I get no records, but on
the other machines i get records. My SQL code looks something like this:

SELECT COUNT(*) AS Expr1
FROM WorkRequest
WHERE (StartDate >= CONVERT(DATETIME, ' 01 / 11 / 2005 ', 103))

Can anyone suggest why this may be?

Thanks

Ste

[Uri Dor]

why not
WHERE (StartDate >= '051101'))
(that's Nov. 1st)

Steve wrote:

I have a windows app running on several machines. Some are XP some are 2000
and a couple are NT SP 6. I have a search screen which can search on date.
When searching on date using the NT machine client I get no records, but on
the other machines i get records. My SQL code looks something like this:

SELECT COUNT(*) AS Expr1
FROM WorkRequest
WHERE (StartDate >= CONVERT(DATETIME, ' 01 / 11 / 2005 ', 103))

Can anyone suggest why this may be?

Thanks

Ste