Column heading for the previous year date

User_JL3CW

Hi,

There is a report requirement which has dashboard prompt with date(calender).

Date entered as for eg: 12/29/2016.

In my report i have two columns current year date and previous year date.

I have PV (Day_PV), which holds the date entered.

In column heading for the current year date i have written: @{Day_PV}  --- working fine  (displays 12/29/2016).

In column heading for the previous year date i should display (12/29/2015).

I tried the following in the column heading:

TIMESTAMPADD( SQL_TSI_YEAR , -1, Date '@{PDayPV}{2016-03-03}'). But it is not evaluating.

Is there any other way to get this one?

Regards,

Ram.

AkanshAgarwal

You need to create an hidden prompt that generates this presentation variable for previous year.

Regards,

Akansh

User_JL3CW

Please let me know how to do this.

regards,

Ram

User_JL3CW

Hi,

I found the solution.

Thank you.

Regards,

Ram.