Hi ukmar,
You may try to code the select statement something like this:
dtDate = str2date(strFmt('1/%1/2004', intMonth), 123);
select sum(amount) from myTable where
myTable.TransDate >= dtDate && myTable.TransDate <= endmth(dtDate);
Regards,
Sonny Wibawa Adi
[EMAIL PROTECTED] wrote:
I'm sorry but I'm asking if it is possible using X++ not using the dbms.
Thanks
>
>
>SELECT MONTH(<THEDATE>), SUM(<FIELD>) FROM <TABLE>
>
>WHERE YEAR(<THEDATE>) = 2004
>
>GROUP BY MONTH(<THEDATE>)
>
>
>
>Works in msSQL at least
>
>
>
>Pieter
>
>
>
> _____
>
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>Sent: 24. november 2004 15:39
>To: [EMAIL PROTECTED]
>Subject: [development-axapta] Select statement and month
>
>
>
>
>Is There a way in which I can made a select that select only the record
>that in a Date field have a specific month?
>
>select ct where MONTH(ct.myDate) = 2;
>
>The problem is how can I build a select that sum a currency from a table
>groupped by month?
>
>Thank you.
>
>Roberto Ukmar
>Indis S.p.A.
>
>
>
>
>
>
>
>
>Yahoo! Groups Sponsor
>
>ADVERTISEMENT
>click here
><http://us.ard.yahoo.com/SIG=129rd3q7a/M=298184.5639630.6699735.3001176/
>D=groups/S=1705006764:HM/EXP=1101394267/A=2434971/R=0/SIG=11eeoolb0/*htt
>p:/www.netflix.com/Default?mqso=60185400>
>
>
><http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
>s/S=:HM/A=2434971/rand=621297504>
>
>
>
> _____
>
>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]
><mailto:[EMAIL PROTECTED]
>be>
>
>* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
>Service <http://docs.yahoo.com/info/terms/> .
>
>
>
>[Non-text portions of this message have been removed]
>
>
>
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
Yahoo! Groups SponsorADVERTISEMENT
---------------------------------
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.
---------------------------------
Do you Yahoo!?
Take Yahoo! Mail with you! Get it on your mobile phone.
[Non-text portions of this message have been removed]
| Yahoo! Groups Sponsor | |
|
|
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.
