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?