Header Date Question

[jackie1948]

How do I get the Prompt_Month and Prompt_Yr to display in the header with a Maxium enddate.

EX.
Prompt_month = 5
Prompt_yr = 2004

I would like to have the date of May 31,2004 in the header.

 

[DoubleD]

Insert a calculation in your header.
If Oracle is your database it would look like this.

=LastOfMonth(To_Date(Prompt_month || "/1/" || Prompt_yr))



I am what I am based on the decisions I have made.

DoubleD