???sybase + Datatime Error???


Unless you've changed the default date/time setup on your copy of SQLA,
it may be expecting a different format of mm/dd/yy.  However, one thing
you can always be sure of is that the following format is accepted :

So, in your example try :

'select * from fclient where db_mod < ' + FormatDateTime(
'yyyy/mm/dd, TheDate)

Derek Davidson
Get a FREE copy of DK's Audit Components for Delphi from my web site:
Now Includes INFOPOWER Derived components and a demo

(Remove the x to EMail me : der...@mksoft.com)