Prior Month Max Date

[#1]

Hi All

I have a Date field and would like to get the Max(Date) of the previous month.

Tried this expression but it doesn't work quiet nicely.

Date(Max(AddMonths(Date,-1)),'DD/MM/YYYY').

How can I get this?

[#2]

Hi Jyothish

Yes I did, for some reason it doesn't show the correct dates

[#3]

It is not maxing the prior month date but shows me the same date as currently selected

[stigchel]

That is because that expression is taking the max from (one month subtracted for each date) which is the current max e.g. May 26 and then one month subtracted so April26. If you want the max of the previous month use as suggested

Max({<Date={"<$(=MonthStart(Max(Date)))"}>} Date)

[#5]

Hi Piet

This expression doesn't return any results. can you please post an app where you are using it?

[stigchel · Accepted solution]

Sure, see text box

[#7]

Thanks Piet!