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
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.
