Text Object Calculation

[byrnel0586]

Hi,

I want to create a text box that says: Data Processed From 1/1 of the year prior to the selected year through the max report date of the year prior to selected year. Ex. "Data Processed From 1/1/2016 - 5/31/2016" when 2017 is selected.

I have the first part but am having trouble with the second.

=If(Only(Year),'Data Processed From 1/1/' & (Only(Year)-1))

It doesn't have to be all in one formula, but that would be ideal

[Clever_Anjos]

Maybe

='Data Processed From ' & YearStart(Min(Date)) & ' - ' & YearEnd(Max(Date))

I´m guessing you have a field called Date

[sunny_talwar · Accepted solution]

May be this:

=If(Only(Year),'Data Processed From ' & Date(YearStart(Date, -1), 'M/D/YYYY') & '-' & Date(AddYears(Max(Date), -1), 'M/D/YYYY')

[byrnel0586]

Thank you. It's called ReportDate, but I am needing the year prior to the year that is selected to show.

[byrnel0586]

Thanks again, Sunny!!

[sunny_talwar]

No problem at all