Skip to Content
0
May 20, 2020 at 02:47 PM

WebI Previous Year Date

1738 Views

Hi All,

In WebI , I have Calendar Day (Date time) field in a column. I have to show previous year dates exactly which matches current year in a different column.

I tried 2 variables : 1. ToDate([Calendar Day];"M/d/yyyy") - Calendar day:

2. RelativeDate([Calendar day]; -1; YearPeriod) in the variable

I get #Format error.

I want to be displayed as below:

CurrentYear - 2/1/2019

Previous Year - 2/1/2018

can some one help me on this?