Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi Jyothish
Yes I did, for some reason it doesn't show the correct dates
It is not maxing the prior month date but shows me the same date as currently selected
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)
Hi Piet
This expression doesn't return any results. can you please post an app where you are using it?
Sure, see text box
Thanks Piet!