try this
SELECT InventJournalTrans where
InventJournalTrans.Transdate>=str2date("31/5/2005",123)
&&
InventJournalTrans.Transdate<=str2date("1/6/2005",123)
regards
p.sathi
-----Original Message-----
From: [email protected]
[mailto:[EMAIL PROTECTED] Behalf Of Koh Meng Chiat
Sent: Tuesday, June 21, 2005 2:28 PM
To: [email protected]
Subject: [development-axapta] SQL Syntax in Axapta Table browser
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
___________________________________________________________________________
'Visit us at www.sundaramfinance.com'
___________________________________________________________________________
"This E-mail may contain privileged information and is intended solely for
the addressee, and any disclosure of this information is strictly
prohibited, and may be unlawful. If you have received this mail by mistake,
please inform us immediately and delete this mail. Any information
expressed in this mail does not necessarily reflect the views of SUNDARAM
FINANCE LIMITED. As per SUNDARAM FINANCE LIMITED's policy, unencrypted mail
via Internet is not considered secure".
___________________________________________________________________________
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.
