HI GUYS,

I have this query and my customer are doing manual report . how can i get last week of the month using oracle as my back end in BO Designer. Please look at Txn_posting_date in where clause.

I broke my head twice with the wall. i am new to oracle and universe
Select
AS_OF_DATE
,TXN_POSTING_DATE
,TXN_CODE
,SYS_SUB_PROD_CD
,COUNT(AMOUT) "Total Count"
,SUM(AMOUT) "Total Amount"

from
TXN TABLE

WHERE
AS_OF_DATE ='31-JAN-2008'
AND
TXN_POSTING_DATE > '25-JAN-2008'
AND
AMOUT > 50000


GROUP BY
AS_OF_DATE
,TXN_POSTING_DATE

I think u need last seven days of the month .. not last week of the month..
everymonth have 5 weeks.. last week means.. start on 29th..
kk