???sybase + Datatime Error???

Richard

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 :
'yyyy/mm/dd'.

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:
http://freespace.{*word*269}.net/d.davidson
Now Includes INFOPOWER Derived components and a demo

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