How about Month(dob)=6?
-----Original Message----- From: advanced_delphi@yahoogroups.com on behalf of Nugroho Adi Prasetyo Sent: Sun 6/8/2008 3:21 PM To: advanced_delphi@yahoogroups.com Subject: [advanced_delphi] Filtering month from table into delphi Hi all, To the point,i have a problem with filtering a date especially a month in one of my table.i give you an example: i have a table called employee.the field is like this (only simple one) 1.employee_id 2.Name 3.Address 4.Dob(date of birth)--dd/mm/yyyy and the data like this ====================================================================== Employee_id|Name |Adresss |DOB(dd/mm/yyyy) ====================================================================== 001 |Andrew |North Jakarta |05/06/1984 002 |Jack |South Jakarta |27/06/1979 003 |Peter |South Jakarta |02/02/1984 ====================================================================== i wanna show only employee who got a birhday in months 6 (June),in that table only showed Andrew and Jack. i wanna implement that filter in Delphi.Just for your information i used Database Desktop because it's only standalone Software. Thanks for your response,sorry if my english bad. Regards, Nugie ^V^
<<winmail.dat>>
