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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top