BO Designer Last week of the month
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
Re: BO Designer Last week of the month
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
