May i know what is mkdate (dd,mm,yyyy) used for??
Best Regars,
Jack Koh
--- Anil Ozay <[EMAIL PROTECTED]> wrote:
> Hi Jack,
>
> Use this statement :
>
> SELECT InventTransPosting where
> InventTransPosting.TransDate >= mkdate(30,04,2005)
> &&
> InventTransPosting.TransDate <= mkdate(31,05,2005)
>
> Best Regards,
>
> Anýl Özay
>
> --- In [email protected], Koh Meng
> Chiat
> <[EMAIL PROTECTED]> wrote:
> > Hello all,
> >
> > The SQL statement i wrote to filter out the
> records
> > doesn't work in table browser. Could anyone shed
> some
> > lights on it??
> >
> > SELECT * FROM InventTransPosting where
> > InventTransPosting.Transdate >="4/30/2005" and
> > InvenTransPosting.Transdate <="5/31/2005";
> >
> > Thanks in advance.
> >
> > Best Regards,
> >
> > Jack
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam? Yahoo! Mail has the best spam
> protection around
> > http://mail.yahoo.com
>
>
>
>
>
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
