Board index » delphi » Filter on date field

Filter on date field


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
Phone: 631.592.1200
Fax:     631.592.1208


Re:Filter on date field

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

(TeamB cannot answer questions received via email)

Other Threads