Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Column heading for the previous year date

Received Response
1
Views
3
Comments
Rank 6 - Analytics Lead

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

Welcome!

It looks like you're new here. Sign in or register to get started.