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?
Sure, see text box
Hi tstewart
You have two functions MonthStart() and MonthEnd()
Date(MonthEnd(AddMonths(Date,-1)),'DD/MM/YYYY').
Hope this helps you
Joaquín
try monthstart(Date)-1
Hi Tumelo,
Try like this:
Max(Date(AddMonths(Date,-1),'DD/MM/YYYY'))
Regards
KC
try this
=MonthsEnd(1,(date(AddMonths(today(),-1),'DD/MM/YYYY')))
Replace date field with today()
Hi Joaquin
MonthEnd and MonthStart would not help me as I specifically want to consider the last date of each month in the dataset
Hi Tumelo,
Try like this
=Date(AddMonths(Max(Date),-1),'DD/MM/YYYY')
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
Try with
Max({<Date={"<$(=MonthStart(Max(Date)))"}>} Date)
Did you tried my expression? It should work dynamically.
Regards
KC