Thanks Steffen, But I wrote wrong word in my reply message to Rosyee. Sufficient must be efficient. I know that query will bring me the result but speed will not be high as I wish. Because all the records will be checked if the person is born today in code. But I want that case be checked by sql server not by axapta. Glad to describe my problem to you. (If I could)...
Best Regards... Ali Ihsan --- In [email protected], "Steffen Denize" <[EMAIL PROTECTED]> wrote: > > 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 <rosyee@> 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 <mbelugin@> 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 > <aliihsanagca@<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] >
