Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Guys,
Happy new year and best wishes
I have a year fields that contains year since 2013, I would like to display only year 2017. Any idea please?
Thanks
Hi
You can use max(year)
You want the max year or the 2017 as the year ??
if(Year='2017',Year)
or
based on selection max year
max(Year)
Create a text Box and write the Expression max(Year). But when ever there is a change in selection like if Old Years are selected, this Text Box shows the corresponding selection or max of the corresponding selections. If we want to show the text Box max year irrespective of selections, then use Max({1} Year).
I think max({1} field name) will give you the answer.