Johny ( XXXX@XXXXX.COM ) moved some electrons around and created
that exception is coming from the sql server, not from delphi. most likely the
reason query analyser does not give the error is because it does the
it means that sql server does not like the format you are using.
have a look at SET DATEFORMAT in the sql online docs and put that into your
there was also a post in this group a few days back titles "set dateformat
problem" which dealt with the same sort of issue.
robert at sadev dot co dot za