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 [email protected], 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 [email protected]<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, http://belugin.info , ICQ:9406811 > > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > -- > > Max Belugin, http://belugin.info , ICQ:9406811 > > > > > > > [Non-text portions of this message have been removed] >
