How to get the date dynamically in report page

[Sarayucog]

I have report. I am creating that report with the SQL query directly. I am not using any package. In that SQL I have WHERE conditions. Like date between 'FROM_DATE' and 'TO_DATE'

The FORM_DATE is fixed it won't be change.
The TO_DATE is vary. For this I had written on function to get the date dynamically.
So the report have the FROM_DATE and will take the TO_DATE dynamically and it will give the result.

My problem is I want to display the FROM_DATE and TO_DATE on the report page.

Here also FROM_DATE is fixed, but I want to get the TO_DATE dynamically (automatically). How it is.

Your help will be appriciated.

Thanks in advance
Sarayu

[MFGF]

I have report. I am creating that report with the SQL query directly. I am not using any package.

Why would you cause yourself such headaches by doing this?

The TO_DATE is vary. For this I had written on function to get the date dynamically.
So the report have the FROM_DATE and will take the TO_DATE dynamically and it will give the result.

Can you explain what you mean by this?  Did you add a prompt macro to the SQL?  Are you using any parameters?

My problem is I want to display the FROM_DATE and TO_DATE on the report page.

Here also FROM_DATE is fixed, but I want to get the TO_DATE dynamically (automatically). How it is.

If you are using a prompt macro to inject TO_DATE, simply add a layout calculation that references the relevant parameter used in the prompt.

If not, add a singleton query that calls the same functionality as the main query to derive the TO_DATE.

MF.

[mvjcognos]

Ur question is from_date is fixed and to_date should display in the report header automatically
s it is possible by using sysdate or report date from functions in the layout calculation in the place of to_date cal..........