Board index » delphi » Filter on date field

Filter on date field

Hello,

Can someone give me an example of how to set a TTable filter on the year of
a date field.
I need to do something like this to my dataset:
Table1.Filter := 'Year(date) = 2000';

--
Tom Pinto
Information Technology Manager
SK Archiving and Retrieval Services
EMail:  SK...@SKArchiving.com
Phone: 631.592.1200
Fax:     631.592.1208

 

Re:Filter on date field


Date >= '1/1/2000 and Date <= '12/31/2000'

--
Bill
(TeamB cannot answer questions received via email)

Other Threads