Hi Ali If you change emplTable to contactPerson in the select statement from Rosyee you will find all persons who have birthday today, no matter how many person there are in the given table.
Best regards, Steffen Fra: [email protected] [mailto:[EMAIL PROTECTED] På vegne af Ali Ýhsan Aðca Sendt: 24. oktober 2007 12:52 Til: [email protected] Emne: [development-axapta] Re: How To Find Persons who born today ? (birthdate) Thanks Rosyee, But I have to find persons from ContactPerson table. And there more than 200.000 records in there. And this method will not be sufficient for finding 5 or maybe max 10 person from there. Best Regards... --- In HYPERLINK "mailto:development-axapta%40yahoogroups.com"[EMAIL PROTECTED] com, Rosyee <[EMAIL PROTECTED]> wrote: > > Hi Ali, > > You can use like this > > while Select emplTable > { > if( mthofyr(emplTable.BirthDate) == mthofyr(today()) > && dayofmth(emplTable.BirthDate) == dayofmth(today())) > { > //u'll get records who born on same day as today > } > } > > Hope this is what you are looking for. > > Thanks, > Rosyee > > > On 10/24/07, Max Belugin <[EMAIL PROTECTED]> wrote: > > > > I'd prefer to extract month and day numbers to separate fields. > > > > But you can use Connection and native queries > > > > On 10/23/07, Ali Ýhsan Aðca <[EMAIL PROTECTED]<aliihsanagca%40gmail.com>> > > wrote: > > > I thought so. But I think there must be a way to include that case in > > > query filter string > > > > > > Thanks... > > > > > > --- In HYPERLINK "mailto:development-axapta%40yahoogroups.com"[EMAIL PROTECTED] com<development-axapta%40yahoogroups.com>, > > "Max Belugin" > > > <mbelugin@> wrote: > > > > > > > > I think, the only way is to enumerate dates from today back to 1900. > > > > (AFAIK there is no way to store dates prior to 1900) > > > > > > > > On 10/22/07, Ali Ã�hsan Aðca <aliihsanagca@> wrote: > > > > > I want to find the persons who were born today? > > > > > What is the filter for that query? > > > > > > > > > > Thanks in advance... > > > > > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > Max Belugin, HYPERLINK "http://belugin.info"http://belugin.info , ICQ:9406811 > > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > -- > > Max Belugin, HYPERLINK "http://belugin.info"http://belugin.info , ICQ:9406811 > > > > > > > [Non-text portions of this message have been removed] > No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.15.9/1090 - Release Date: 24-10-2007 08:48 No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.15.9/1090 - Release Date: 24-10-2007 08:48 [Non-text portions of this message have been removed]
