Home » Developer & Programmer » Forms » date field - need to group by month
date field - need to group by month [message #77665] Thu, 01 November 2001 05:19 Go to next message
Messages: 17
Registered: November 2001
Junior Member
How do I get the date field (type date) to group by month for my year-end ledger balance? The ledger entries are recorded by day, month, and year. I am using Oracle Developer/Report.

Thank you for any help on this.


Re: date field - need to group by month [message #77667 is a reply to message #77665] Thu, 01 November 2001 08:46 Go to previous message
Messages: 73
Registered: October 2001
Dear Dov,
U can use simple substr function to cut month from date field. Like
select .... from... where...group by substr(datefield,4,7)

If can/ cannot solve ur problem in this way let me know.


Previous Topic: Re: Book on Forms 6i??????????
Next Topic: Form Caution
Goto Forum:

Current Time: Wed Dec 01 10:24:18 CST 2021