Prepare for your Next Interview
This is a discussion on BO Designer Last week of the month within the Data Warehousing forums, part of the Databases category; 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 ...
|
|||
|
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 |
| Sponsored Links |
|
|||
|
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 |
![]() |
|
| Thread Tools | |
| Display Modes | |
|
|
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Form Designer and Initialize Component | Geek_Guest | C# | 1 | 11-20-2007 07:05 AM |
| Redirect to week.php instead of login.php | Geek_Guest | PHP | 0 | 05-16-2007 02:10 PM |
| Display record ordered by the day of the week | orlando | SQL | 3 | 03-01-2007 03:04 AM |
| CSS Tab Designer | psuresh1982 | HTML & CSS | 4 | 01-31-2007 01:38 AM |
| Page Designer | Lokesh M | HTML & CSS | 0 | 06-26-2006 08:33 AM |