topic Re: Last Year Max date in App Development

Last Year Max date

soha1902 — Fri, 23 Apr 2021 07:22:40 GMT

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.

tresB — Fri, 23 Apr 2021 07:56:06 GMT

Assuming you have a Year field as well, try:

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

soha1902 — Fri, 23 Apr 2021 08:11:12 GMT

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.

tresB — Fri, 23 Apr 2021 08:37:32 GMT

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