You may have to filter based on a date/time range becasue a date/time is an
exact (to 1 sec) match so you need to run frmm midnight to midnight.


-----Original Message-----
From: John Christenhusz <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Date: Wednesday, 17 February 1999 13:08
Subject: [DUG]: Filter Date/Time


>Hi all,
>
>How can you filter a table on a field type Date, Time or DateTime.
>
>With an SQL you can say:
>
>sql.add(....., where "Date" = :MyDate)
>paramByName('MyDate').asDate := now;
>
>
>Is there anything similar for defining a table-filter property on a
>date/time-field?
>
>
>
>Thanks,
>
>John Christenhusz
>POSTEC DATA SYSTEMS Ltd.
>PO Box 302-230
>Auckland, New Zealand
>E-mail: [EMAIL PROTECTED]
>Phone: 09-415.8803
>Fax: 09-415.9042
>
>
>

---------------------------------------------------------------------------
    New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
                  Website: http://www.delphi.org.nz

Reply via email to