This is the code I have for filtering an activity log :
FSEventViewer1.GetNavDataSet.Filter :=
'LOGDATE >= ''' + FormatDateTime('dd/mm/yyyy', DateTimeBegin.Date) +
''' AND LOGDATE <= ''' + FormatDateTime('dd/mm/yyyy', DateTimeEnd.Date)
+ '''';
This replies on having the bde date format mode set to 1.
Andrew Masters <[EMAIL PROTECTED]> on 19/04/99 11:25:11
Please respond to [EMAIL PROTECTED]
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
cc: (bcc: Peter Jones/Logistics&Information
Technology/Christchurch/Foodstuffs)
Subject: [DUG]: Filters
Simple one hopefully ? Does anyone know the syntax for using a date in a
filter expression. I've tried heaps of formats and it always tells me my
expression is invalid. This doesn't appear to be well documented.
Thanks
Andrew Masters
Clinical Solutions Ltd
Auckland, NZ
Ph: +64-9-476-0106
Fax: +64-9-476-0108
e: [EMAIL PROTECTED]
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
