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"
> > <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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]
