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
What is a Cube?
Can you define set to be cardinality?
What are all the components of Report Studio?
What is defined as Query studio?
What is cognos powerhouse?
is cognos 7 is better than cognos 8
What do you understand by the term 'aggregate advisor?'
what is the difference between filter and condition?
Explain the difference between native sql and cognos sql?
What is the difference between drill through, drill across?
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
what is the main advantage of impromptu over cognos reportnet?
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
How we check the errors before running the report?
hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com