I have prompt date prompt (from and to), country and city,
how to get data from jan1/2012 to jan31-2012.
Answer Posted / srini madhala
For example if you are in Mar2012:-
_add_months(sysdate,-2) which takes you into Jan2012.
After this convert the _add_months(sysdate,-2) to t0_char or to_date as required.
| Is This Answer Correct ? | 0 Yes | 7 No |
Post New Answer View All Answers
How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?
What is the difference between low affinity and high affinity connections?
Can you define framework manager?
Can you define folder?
----------------Diff b/w Dimensional modeling and Relational modeling?
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
Can you define a datastore in cognos?
What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days
What is cognos powerhouse?
What is the deployment requirements used in cognos?
i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..
What are all the types of hierarchies?
What is Fullouterjoin?
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance