| |
GeekInterview.com > Interview Questions > Data Warehousing > Cognos
| Print | |
Question: use this query i am retriving all years OCt data from 01-10-2004 to 30-10-2007
i need to restrect this query to current date and current year
[gosales_goretailers].[Orders].[Order month]between 01 and to_number(to_char(current_date,'MM'))and [gosales_goretailers].[Orders].[Order month]=to_number(to_char(current_date,'MM'))
pass polar ID
|
| November 11, 2005 09:09:06 |
#1 |
| raju |
Member Since: Visitor Total Comments: N/A |
RE: use this query i am retriving all years OCt data f...
|
You have a function called 'extract' in cognos. Ex:- extract(month,the dte field). by giving like this you will get month. so you can keep a filter to restrict the rows only for october. |
| |
Back To Question | |
