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?

[JoaquinLazaro]

Hi tstewart

You have two functions MonthStart() and MonthEnd()

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

Hope this helps you

Joaquín

[john_s_w_wood]

try monthstart(Date)-1

[jyothish8807]

Hi Tumelo,

Try like this:

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

Regards

KC

[#5]

try this

=MonthsEnd(1,(date(AddMonths(today(),-1),'DD/MM/YYYY')))

Replace date field with today()

[#6]

Hi Joaquin

MonthEnd and MonthStart would not help me as I specifically want to consider the last date of each month in the dataset

[MayilVahanan]

Hi Tumelo,

Try like this

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

[#8]

I want the expression to be dynamic e.g if last month's last sales day was 2015/04/28, This is the date I want to see from the expression. When I select any prior date, it should show me that date's previous month last date in the dataset

[stigchel]

Try with

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

[jyothish8807]

Did you tried my expression? It should work dynamically.

Regards

KC