OraFAQ Forum: Forms » date field - need to group by month

Home » Developer & Programmer » Forms » date field - need to group by month

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

date field - need to group by month [message #77665]

Thu, 01 November 2001 05:19

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

Deb

----------------------------------------------------------------------

Report message to a moderator

Re: date field - need to group by month [message #77667 is a reply to message #77665]

Thu, 01 November 2001 08:46

Robin
Messages: 73
Registered: October 2001

Member

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.

Thanks
Robin

----------------------------------------------------------------------

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 17 03:16:44 CDT 2025