Why not create a calculated field called DaysUntilDOB and have it calculate the days between Now and their DOBs. Then you can use Delphi filters to show only fields where DaysUntilDOB <= 180 (6 months). XFX nForce 680i LT SLI Socket 775 | Intel Core 2 Duo E6750 OC:1600 FSB @ 3.2 MHz | 2 x OCZ SLI 1024MB PC6400 DDR2 800MHz| XION 600w PSU | CM Stacker 200 ATX/BTX Case | EVGA GeForce 8800 GTS 512 | WD SATA 74 GB Raptor (boot,system), WD SATA 500 GB (storage) | Windows XP Pro, SP2 | Patient and supportive significant other
To: [EMAIL PROTECTED]: [EMAIL PROTECTED]: Sun, 8 Jun 2008 22:21:18 +0000Subject: [advanced_delphi] Filtering month from table into delphi Hi all,To the point,i have a problem with filtering a date especially a monthin 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_id2.Name3.Address4.Dob(date of birth)--dd/mm/yyyyand the data like this======================================================================Employee_id|Name |Adresss |DOB(dd/mm/yyyy)======================================================================001 |Andrew |North Jakarta |05/06/1984002 |Jack |South Jakarta |27/06/1979003 |Peter |South Jakarta |02/02/1984======================================================================i wanna show only employee who got a birhday in months 6 (June),inthat table only showed Andrew and Jack.i wanna implement that filter in Delphi.Just for your information iused Database Desktop because it's only standalone Software.Thanks for your response,sorry if my english bad.Regards,Nugie ^V^ _________________________________________________________________ Now you can invite friends from Facebook and other groups to join you on Windows Live™ Messenger. Add now. https://www.invite2messenger.net/im/?source=TXT_EML_WLH_AddNow_Now
