Last Year Max date

[soha1902]

Hi All,

I have One Date field that contains Data like

Date

2020-03-31

2019-12-28

2019-12-25

Now my requirement is when User select any Date then in text box I want to show Last Year Max Date.

For example If user select 2020-03-12 then 2019-12-28 will be displayed in text box. Please help me get this.

[tresesco]

Assuming you have a Year field as well, try:

=Date(Max({<Date,Year={'$(=Year(Max(Date))-1)'}>}Date))

[soha1902]

Thanks for your reply..but its showing  the 2019-12-31 .

I want available max date(in my case its 2019-12-28) for last year not last year end date. I given example also in my question.

[tresesco · Accepted solution]

If your date field doesn't have a date, the expression can't show that.